Open Flash Chart

對於折線圖，只需要給予XY軸序列 <OBJECT id=BuyingTrendOfc classid=clsid:D27CDB6E-AE6D-11cf-96B8-444553540000 width=720 height="100%"><PARAM NAME="_cx" VALUE="5080"><PARAM NAME="_cy" VALUE="5080"><PARAM NAME="FlashVars" VALUE=""><PARAM NAME="Movie" VALUE="/ibank/html/javascript/js/util/openFlashChart/open-flash-chart.swf"><PARAM NAME="Src" VALUE="/ibank/html/javascript/js/util/openFlashChart/open-flash-chart.swf"><PARAM NAME="WMode" VALUE="Window"><PARAM NAME="Play" VALUE="0"><PARAM NAME="Loop" VALUE="-1"><PARAM NAME="Quality" VALUE="High"><PARAM NAME="SAlign" VALUE="LT"><PARAM NAME="Menu" VALUE="-1"><PARAM NAME="Base" VALUE=""><PARAM NAME="AllowScriptAccess" VALUE="always"><PARAM NAME="Scale" VALUE="NoScale"><PARAM NAME="DeviceFont" VALUE="0"><PARAM NAME="EmbedMovie" VALUE="0"><PARAM NAME="BGColor" VALUE="FFFFFF"><PARAM NAME="SWRemote" VALUE=""><PARAM NAME="MovieData" VALUE=""><PARAM NAME="SeamlessTabbing" VALUE="1"><PARAM NAME="Profile" VALUE="0"><PARAM NAME="ProfileAddress" VALUE=""><PARAM NAME="ProfilePort" VALUE="0"><PARAM NAME="AllowNetworking" VALUE="all"><PARAM NAME="AllowFullScreen" VALUE="false"></OBJECT></DIV> <SCRIPT type=text/javascript> var x = new SWFObject("/ibank/html/javascript/js/util/openFlashChart/open-flash-chart.swf","BuyingTrendOfc","720px","100%","9","#FFFFFF"); x.addParam("quality","high"); x.addParam("allowScriptAccess","always"); x.addVariable("variables","true"); x.addVariable("bg_colour","#FFFFD7"); x.addVariable("x_axis_colour","#C77DAA"); x.addVariable("x_grid_colour","#F0F0F0"); x.addVariable("y_axis_colour","#C77DAA"); x.addVariable("y_grid_colour","#F0F0F0"); x.addVariable("inner_background","#FFFFDD,#FFFFDD,90"); x.addVariable("num_decimals","4"); x.addVariable("is_fixed_num_decimals_forced","true"); x.addVariable("y_ticks","5,8,10"); x.addVariable("x_label_style","9,#303030,1"); x.addVariable("x_legend","DATE,12,#736AFF"); x.addVariable("y_legend","RATE,12,#736AFF"); x.addVariable("y_label_size","9"); x.addVariable("x_axis_steps","1"); x.addVariable("y_axis_steps","1"); x.addVariable("line","3,#FC7298,紐西蘭幣(NZD),12,0"); x.addVariable("values","22.4757,22.2819,22.4484,22.3486,22.2883,22.0687,22.1735,22.3106,22.6414,22.6813,22.6126,22.4877,22.8178,22.6708,22.6967,23.0123,22.9627,22.9244,22.6673,23.2632,23.3329,23.2893,23.1995,23.0162,23.0634,23.0792,23.1544,22.9107,23.0539,23.5050,23.6104,23.6161,23.6274,23.5248,23.6931,23.8077,23.8832,23.8418,24.0313,24.1822,24.2129,24.2503,24.3686"); x.addVariable("x_labels","98/08/26,98/08/27,98/08/28,98/08/31,98/09/01,98/09/02,98/09/03,98/09/04,98/09/07,98/09/08,98/09/09,98/09/10,98/09/11,98/09/14,98/09/15,98/09/16,98/09/17,98/09/18,98/09/21,98/09/22,98/09/23,98/09/24,98/09/25,98/09/28,98/09/29,98/09/30,98/10/01,98/10/02,98/10/05,98/10/06,98/10/07,98/10/08,98/10/09,98/10/12,98/10/13,98/10/14,98/10/15,98/10/16,98/10/19,98/10/20,98/10/21,98/10/22,98/10/23"); x.addVariable("y_min","22.0687"); x.addVariable("y_max","24.3686"); x.addVariable("tool_tip","#x_label#<br>#key# #val#"); x.write("BuyingTrendChart"); </SCRIPT> http://teethgrinder.co.uk/open-flash-chart/

Using regular expression in MSSQL/TSQL

User Define Function:

CREATE FUNCTION dbo.find_regular_expression
(
@source varchar(5000),
@regexp varchar(1000),
@ignorecase bit = 0
)
RETURNS bit
AS
BEGIN
DECLARE @hr integer
DECLARE @objRegExp integer
DECLARE @objMatches integer
DECLARE @objMatch integer
DECLARE @count integer
DECLARE @results bit

EXEC @hr = sp_OACreate 'VBScript.RegExp', @objRegExp OUTPUT
IF @hr <> 0 BEGIN
SET @results = 0
RETURN @results
END
EXEC @hr = sp_OASetProperty @objRegExp, 'Pattern', @regexp
IF @hr <> 0 BEGIN
SET @results = 0
RETURN @results
END
EXEC @hr = sp_OASetProperty @objRegExp, 'Global', false
IF @hr <> 0 BEGIN
SET @results = 0
RETURN @results
END
EXEC @hr = sp_OASetProperty @objRegExp, 'IgnoreCase', @ignorecase
IF @hr <> 0 BEGIN
SET @results = 0
RETURN @results
END
EXEC @hr = sp_OAMethod @objRegExp, 'Test', @results OUTPUT, @source
IF @hr <> 0 BEGIN
SET @results = 0
RETURN @results
END
EXEC @hr = sp_OADestroy @objRegExp
IF @hr <> 0 BEGIN
SET @results = 0
RETURN @results
END
RETURN @results
END