3D High Low Close Chart SQL Script

-------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 3D High Low Close Chart
--
--   Notes: The query below will work on the following database servers:
--          MS SQL Server, Sybase ASE, Sybase IQ, Sybase Anywhere, MySQL, PostreSQL
--
--   ORACLE: To make the query below work in Oracle, add " FROM DUAL" at the end of each SELECT         
--   DB2: To make the query below work in DB2, add " FROM SYSIBM.SYSDUMMY1" at the end of each SELECT
-------------------------------------------------------------------------------------------------------------------------------------------------------------

SELECT '1', 'BBC' as 'Company',30 as 'high', 10 as 'low', 27 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '2', 'CBC' as 'Company', 30 as 'high', 15 as 'low', 20 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '3', 'ABC' as 'Company', 70 as 'high', 63 as 'low', 68 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '4', 'STC' as 'Company', 59 as 'high', 46 as 'low', 57 as 'close', '20081209 13:12:43.280' as 'date'
union
SELECT '5', 'WIP' as 'Company', 9 as 'high', 3 as 'low', 5 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '6', 'INF' as 'Company', 23 as 'high', 12 as 'low', 22 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '7', 'ADS' as 'Company', 50 as 'high', 38 as 'low', 47 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '8', 'TOA' as 'Company', 60 as 'high', 40 as 'low', 55 as 'close', '20081209 13:12:43.280' as 'date'
union
SELECT '9', 'CAA' as 'Company', 55 as 'high', 42 as 'low', 48 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '10', 'YAH' as 'Company', 65 as 'high', 54 as 'low', 58 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '11', 'MIC' as 'Company', 80 as 'high', 65 as 'low', 74 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '12', 'TCS' as 'Company', 65 as 'high', 40 as 'low', 55 as 'close', '20081209 13:12:43.280' as 'date'
union
SELECT '13', 'CRA' as 'Company', 35 as 'high', 10 as 'low', 30 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '14', 'TWI' as 'Company', 40 as 'high', 20 as 'low', 28 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '15', 'GOO' as 'Company', 76 as 'high', 46 as 'low', 65 as 'close', '20081209 13:12:43.280' as 'date'
UNION
SELECT '16', 'PLU' as 'Company', 55 as 'high', 32 as 'low', 42 as 'close', '20081209 13:12:43.280' as 'date'
GO
.setResultSettings 'Index=1,
     CategoryFields="[Company]",
     SeriesFields="[high] ASC,[low],[close]",
     ShowChart=true,
     ShowToolbar=true,
     Paging=true,
     Split=300,
     Chart="{highlowclose,highlowclose,highlowclose}",
     RotX=320,
     RotY=-359,
     RotZ=0,
     Zoom=17.606081,
     ScaleData=true,
     ShowLegend=true,
     ShowGrid=true,
     Title="3D HLC Chart",
     PieExplode=0.0,
     GroupSmallValues=true,
     SmallValuesThreshold=3.0,
     PieLabelDistance=3.0,
     PieShowLines=false,
     LineWidth=1.0,
     Width=16.0,
     Height=10.0,
     Depth=4.0,
     SeriesSpacing=0.5,
     CategorySpacing=0.5,
     Font="Arial-6",
     TopColor="#D7DCF5",
     BottomColor="#EBF0F5",
     PanX=-8.499999,
     PanY=-3.099999,
     Lighting=Dark,
     View2D=false,
     StackedPercent=false,
     ShowValueAxis=true,
     ShowCategoryAxis=true,
     ShowSeriesAxis=false,
     ValueAxisNumberFormat="###0",
     CategoryAxisNumberFormat="#,##0",
     NumericCategoryAxis=false,
     MergeAxis=true,
     SeriesAlias="default,default,default",
     SeriesSubType="High,Low,Close",
     SeriesColumnType="Cube,Cube,Cube",
     SeriesMin="default,default,default",
     SeriesMax="default,default,default",
     SeriesColor="default,default,default",
     SeriesFunctionMetaData="true,true,true",
     LegendPosition=Top Right,
     LegendWidthType=Exact,
     LegendWidth=100,
     LegendHeightType=Fit,
     LegendHeight=160,
     ShowFixedCategoryCount=true,
     FixedCategoryCount=0'