ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW...

I am running the following query with and without two following lines:

ROWS BETWEEN UNBOUNDED PRECEDING
AND CURRENT ROW

There result are identical.

Question: What is the purpose of these two lines? Why to have them?

FYI, I am reading about this and trying to understand its purpose.  SQL Server 2012.

SELECT custid, orderid, orderdate, val,
SUM(val) OVER(PARTITION BY custid
ORDER BY orderdate, orderid)AS runningtotal
--ROWS BETWEEN UNBOUNDED PRECEDING
--AND CURRENT ROW
) AS runningtotal
FROM Sales.OrderValues;

Open in new window


Partial output:
1	10643	2007-08-25 00:00:00.000	814.50	814.50
1	10692	2007-10-03 00:00:00.000	878.00	1692.50
1	10702	2007-10-13 00:00:00.000	330.00	2022.50
1	10835	2008-01-15 00:00:00.000	845.80	2868.30
1	10952	2008-03-16 00:00:00.000	471.20	3339.50
1	11011	2008-04-09 00:00:00.000	933.50	4273.00
2	10308	2006-09-18 00:00:00.000	88.80	88.80
2	10625	2007-08-08 00:00:00.000	479.75	568.55

Open in new window

LVL 34
Mike EghtebasDatabase and Application DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rajkumar GsSoftware EngineerCommented:
Hi
Do you mean the lines
--ROWS BETWEEN UNBOUNDED PRECEDING
--AND CURRENT ROW

This is just comments in sql. which will be ignored if starts a line with two hyphens.

Used to write the purpose of the query, which would be understandable by others

If you mean to ask something else, pls ask specifically

Raj
0
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
I am running the following query with and without two following lines:

ROWS BETWEEN UNBOUNDED PRECEDING
AND CURRENT ROW
0
Rajkumar GsSoftware EngineerCommented:
please post those two queries
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Mike EghtebasDatabase and Application DeveloperAuthor Commented:
SELECT custid, orderid, orderdate, val,
SUM(val) OVER(PARTITION BY custid
ORDER BY orderdate, orderid)AS runningtotal
) AS runningtotal
FROM Sales.OrderValues;

Open in new window


SELECT custid, orderid, orderdate, val,
SUM(val) OVER(PARTITION BY custid
ORDER BY orderdate, orderid)AS runningtotal
ROWS BETWEEN UNBOUNDED PRECEDING
AND CURRENT ROW
) AS runningtotal
FROM Sales.OrderValues;

Open in new window


I was just trying to reduce the length of my post apparently I have failed on that.

Also, I see that

ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW could be reduced to:
ROWS UNBOUNDED PRECEDING
0
Rajkumar GsSoftware EngineerCommented:
I am sorry.

As per my knowledge , I am not aware of these keywords in MS SQL Server.

I suspect this is an Oracle question.  If so, Please tag Oracle instead of Sql server
0
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
no it is tsql and it may also apply to oracle.
0
Deepak ChauhanSQL Server DBACommented:
This is new in sql server 2012. Detailed info here...
https://msdn.microsoft.com/en-us/library/ms189461.aspx
0
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
How these two versions work? I want to understand its mechanisim.

SELECT custid, orderid, orderdate, val,
SUM(val) OVER(PARTITION BY custid
ORDER BY orderdate, orderid
ROWS BETWEEN 2 PRECEDING
AND CURRENT ROW) AS runningtotal
FROM Sales.OrderValues;

1	10643	2007-08-25 00:00:00.000	814.50	814.50
1	10692	2007-10-03 00:00:00.000	878.00	1692.50
1	10702	2007-10-13 00:00:00.000	330.00	2022.50
1	10835	2008-01-15 00:00:00.000	845.80	2053.80
1	10952	2008-03-16 00:00:00.000	471.20	1647.00
1	11011	2008-04-09 00:00:00.000	933.50	2250.50
2	10308	2006-09-18 00:00:00.000	88.80	88.80
2	10625	2007-08-08 00:00:00.000	479.75	568.55
2	10759	2007-11-28 00:00:00.000	320.00	888.55
2	10926	2008-03-04 00:00:00.000	514.40	1314.15
3	10365	2006-11-27 00:00:00.000	403.20	403.20
3	10507	2007-04-15 00:00:00.000	749.06	1152.26
3	10535	2007-05-13 00:00:00.000	1940.85	3093.11
3	10573	2007-06-19 00:00:00.000	2082.00	4771.91
3	10677	2007-09-22 00:00:00.000	813.37	4836.22
3	10682	2007-09-25 00:00:00.000	375.50	3270.87
3	10856	2008-01-28 00:00:00.000	660.00	1848.87
4	10355	2006-11-15 00:00:00.000	480.00	480.00
4	10383	2006-12-16 00:00:00.000	899.00	1379.00
4	10453	2007-02-21 00:00:00.000	407.70	1786.70
4	10558	2007-06-04 00:00:00.000	2142.90	3449.60
4	10707	2007-10-16 00:00:00.000	1641.00	4191.60
4	10741	2007-11-14 00:00:00.000	228.00	4011.90
4	10743	2007-11-17 00:00:00.000	319.20	2188.20
4	10768	2007-12-08 00:00:00.000	1477.00	2024.20
4	10793	2007-12-24 00:00:00.000	191.10	1987.30
4	10864	2008-02-02 00:00:00.000	282.00	1950.10
4	10920	2008-03-03 00:00:00.000	390.00	863.10
4	10953	2008-03-16 00:00:00.000	4441.25	5113.25
4	11016	2008-04-10 00:00:00.000	491.50	5322.75
5	10278	2006-08-12 00:00:00.000	1488.80	1488.80
5	10280	2006-08-14 00:00:00.000	613.20	2102.00
5	10384	2006-12-16 00:00:00.000	2222.40	4324.40
5	10444	2007-02-12 00:00:00.000	1031.70	3867.30
5	10445	2007-02-13 00:00:00.000	174.90	3429.00
5	10524	2007-05-01 00:00:00.000	3192.65	4399.25
5	10572	2007-06-18 00:00:00.000	1501.09	4868.64
5	10626	2007-08-11 00:00:00.000	1503.60	6197.34
5	10654	2007-09-02 00:00:00.000	601.83	3606.52
5	10672	2007-09-17 00:00:00.000	3815.25	5920.68
5	10689	2007-10-01 00:00:00.000	472.50	4889.58
5	10733	2007-11-07 00:00:00.000	1459.00	5746.75
5	10778	2007-12-16 00:00:00.000	96.50	2028.00
5	10837	2008-01-16 00:00:00.000	1064.50	2620.00
5	10857	2008-01-28 00:00:00.000	2048.21	3209.21
5	10866	2008-02-03 00:00:00.000	1096.20	4208.91
5	10875	2008-02-06 00:00:00.000	709.55	3853.96
5	10924	2008-03-04 00:00:00.000	1835.70	3641.45
6	10501	2007-04-09 00:00:00.000	149.00	149.00
6	10509	2007-04-17 00:00:00.000	136.80	285.80
6	10582	2007-06-27 00:00:00.000	330.00	615.80
6	10614	2007-07-29 00:00:00.000	464.00	930.80
6	10853	2008-01-27 00:00:00.000	625.00	1419.00
6	10956	2008-03-17 00:00:00.000	677.00	1766.00
6	11058	2008-04-29 00:00:00.000	858.00	2160.00
7	10265	2006-07-25 00:00:00.000	1176.00	1176.00
7	10297	2006-09-04 00:00:00.000	1420.00	2596.00
7	10360	2006-11-22 00:00:00.000	7390.20	9986.20
7	10436	2007-02-05 00:00:00.000	1994.52	10804.72
7	10449	2007-02-18 00:00:00.000	1838.20	11222.92
7	10559	2007-06-05 00:00:00.000	520.41	4353.13
7	10566	2007-06-12 00:00:00.000	1761.00	4119.61
7	10584	2007-06-30 00:00:00.000	593.75	2875.16
7	10628	2007-08-12 00:00:00.000	450.00	2804.75
7	10679	2007-09-23 00:00:00.000	660.00	1703.75
7	10826	2008-01-12 00:00:00.000	730.00	1840.00
8	10326	2006-10-10 00:00:00.000	982.00	982.00
8	10801	2007-12-29 00:00:00.000	3026.85	4008.85
8	10970	2008-03-24 00:00:00.000	224.00	4232.85
9	10331	2006-10-16 00:00:00.000	88.50	88.50
9	10340	2006-10-29 00:00:00.000	2436.18	2524.68
9	10362	2006-11-25 00:00:00.000	1549.60	4074.28
9	10470	2007-03-11 00:00:00.000	1820.80	5806.58
9	10511	2007-04-18 00:00:00.000	2550.00	5920.40
9	10525	2007-05-02 00:00:00.000	818.40	5189.20
9	10663	2007-09-10 00:00:00.000	1930.40	5298.80
9	10715	2007-10-23 00:00:00.000	1296.00	4044.80
9	10730	2007-11-05 00:00:00.000	484.26	3710.66
9	10732	2007-11-06 00:00:00.000	360.00	2140.26
9	10755	2007-11-26 00:00:00.000	1948.50	2792.76
9	10827	2008-01-12 00:00:00.000	843.00	3151.50
9	10871	2008-02-05 00:00:00.000	1979.23	4770.73
9	10876	2008-02-09 00:00:00.000	917.00	3739.23
9	10932	2008-03-06 00:00:00.000	1788.63	4684.86
9	10940	2008-03-11 00:00:00.000	360.00	3065.63
9	11076	2008-05-06 00:00:00.000	792.75	2941.38
10	10389	2006-12-20 00:00:00.000	1832.80	1832.80
10	10410	2007-01-10 00:00:00.000	802.00	2634.80
10	10411	2007-01-10 00:00:00.000	966.80	3601.60
10	10431	2007-01-30 00:00:00.000	1892.25	3661.05
10	10492	2007-04-01 00:00:00.000	851.20	3710.25
10	10742	2007-11-14 00:00:00.000	3118.00	5861.45
10	10918	2008-03-02 00:00:00.000	1447.50	5416.70
10	10944	2008-03-12 00:00:00.000	1025.33	5590.83
10	10949	2008-03-13 00:00:00.000	4422.00	6894.83
10	10975	2008-03-25 00:00:00.000	717.50	6164.83
10	10982	2008-03-27 00:00:00.000	1014.00	6153.50
10	11027	2008-04-16 00:00:00.000	877.73	2609.23
10	11045	2008-04-23 00:00:00.000	1309.50	3201.23
10	11048	2008-04-24 00:00:00.000	525.00	2712.23
11	10289	2006-08-26 00:00:00.000	479.40	479.40
11	10471	2007-03-11 00:00:00.000	1328.00	1807.40
11	10484	2007-03-24 00:00:00.000	386.20	2193.60
11	10538	2007-05-15 00:00:00.000	139.80	1854.00
11	10539	2007-05-16 00:00:00.000	355.50	881.50
11	10578	2007-06-24 00:00:00.000	477.00	972.30
11	10599	2007-07-15 00:00:00.000	493.00	1325.50
11	10943	2008-03-11 00:00:00.000	711.00	1681.00
11	10947	2008-03-13 00:00:00.000	220.00	1424.00
11	11023	2008-04-14 00:00:00.000	1500.00	2431.00
12	10521	2007-04-29 00:00:00.000	225.50	225.50
12	10782	2007-12-17 00:00:00.000	12.50	238.00
12	10819	2008-01-07 00:00:00.000	477.00	715.00
12	10881	2008-02-11 00:00:00.000	150.00	639.50
12	10937	2008-03-10 00:00:00.000	644.80	1271.80
12	11054	2008-04-28 00:00:00.000	305.00	1099.80
13	10259	2006-07-18 00:00:00.000	100.80	100.80
14	10254	2006-07-11 00:00:00.000	556.62	556.62
14	10370	2006-12-03 00:00:00.000	1117.60	1674.22
14	10519	2007-04-28 00:00:00.000	2314.20	3988.42
14	10731	2007-11-06 00:00:00.000	1890.50	5322.30
14	10746	2007-11-19 00:00:00.000	2311.70	6516.40
14	10966	2008-03-20 00:00:00.000	1098.46	5300.66
14	11029	2008-04-16 00:00:00.000	1286.80	4696.96
14	11041	2008-04-22 00:00:00.000	1773.00	4158.26
15	10290	2006-08-27 00:00:00.000	2169.00	2169.00
15	10466	2007-03-06 00:00:00.000	216.00	2385.00
15	10494	2007-04-02 00:00:00.000	912.00	3297.00
15	10969	2008-03-23 00:00:00.000	108.00	1236.00
15	11042	2008-04-22 00:00:00.000	405.75	1425.75
16	10435	2007-02-04 00:00:00.000	631.60	631.60
16	10462	2007-03-03 00:00:00.000	156.00	787.60
16	10848	2008-01-23 00:00:00.000	931.50	1719.10
17	10363	2006-11-26 00:00:00.000	447.20	447.20
17	10391	2006-12-23 00:00:00.000	86.40	533.60
17	10797	2007-12-25 00:00:00.000	420.00	953.60
17	10825	2008-01-09 00:00:00.000	1030.76	1537.16
17	11036	2008-04-20 00:00:00.000	1692.00	3142.76
17	11067	2008-05-04 00:00:00.000	86.85	2809.61
18	10311	2006-09-20 00:00:00.000	268.80	268.80
18	10609	2007-07-24 00:00:00.000	424.00	692.80
18	10683	2007-09-26 00:00:00.000	63.00	755.80
18	10890	2008-02-16 00:00:00.000	860.10	1347.10
19	10364	2006-11-26 00:00:00.000	950.00	950.00
19	10400	2007-01-01 00:00:00.000	3063.00	4013.00
19	10532	2007-05-09 00:00:00.000	796.35	4809.35
19	10726	2007-11-03 00:00:00.000	655.00	4514.35
19	10987	2008-03-31 00:00:00.000	2772.00	4223.35
19	11024	2008-04-15 00:00:00.000	1966.81	5393.81
19	11047	2008-04-24 00:00:00.000	817.88	5556.69
19	11056	2008-04-28 00:00:00.000	3740.00	6524.69
20	10258	2006-07-17 00:00:00.000	1614.88	1614.88
20	10263	2006-07-23 00:00:00.000	1873.80	3488.68
20	10351	2006-11-11 00:00:00.000	5398.73	8887.41
20	10368	2006-11-29 00:00:00.000	1689.78	8962.31
20	10382	2006-12-13 00:00:00.000	2900.00	9988.51
20	10390	2006-12-23 00:00:00.000	2090.88	6680.66
20	10402	2007-01-02 00:00:00.000	2713.50	7704.38
20	10403	2007-01-03 00:00:00.000	855.02	5659.40
20	10430	2007-01-30 00:00:00.000	4899.20	8467.72
20	10442	2007-02-11 00:00:00.000	1792.00	7546.22
20	10514	2007-04-22 00:00:00.000	8623.45	15314.65
20	10571	2007-06-17 00:00:00.000	550.59	10966.04
20	10595	2007-07-10 00:00:00.000	4725.00	13899.04
20	10633	2007-08-15 00:00:00.000	5510.59	10786.18
20	10667	2007-09-12 00:00:00.000	1536.80	11772.39
20	10698	2007-10-09 00:00:00.000	3436.44	10483.83
20	10764	2007-12-03 00:00:00.000	2286.00	7259.24
20	10771	2007-12-10 00:00:00.000	344.00	6066.44
20	10773	2007-12-11 00:00:00.000	2030.40	4660.40
20	10776	2007-12-15 00:00:00.000	6635.28	9009.68
20	10795	2007-12-24 00:00:00.000	2158.00	10823.68
20	10836	2008-01-16 00:00:00.000	4705.50	13498.78
20	10854	2008-01-27 00:00:00.000	2966.50	9830.00
20	10895	2008-02-18 00:00:00.000	6379.40	14051.40
20	10968	2008-03-23 00:00:00.000	1408.00	10753.90
20	10979	2008-03-26 00:00:00.000	4813.50	12600.90
20	10990	2008-04-01 00:00:00.000	4288.85	10510.35
20	11008	2008-04-08 00:00:00.000	4680.90	13783.25
20	11017	2008-04-13 00:00:00.000	6750.00	15719.75
20	11072	2008-05-05 00:00:00.000	5218.00	16648.90
21	10347	2006-11-06 00:00:00.000	814.42	814.42
21	10386	2006-12-18 00:00:00.000	166.00	980.42
21	10414	2007-01-14 00:00:00.000	224.83	1205.25
21	10512	2007-04-21 00:00:00.000	525.30	916.13
21	10581	2007-06-26 00:00:00.000	310.00	1060.13
21	10650	2007-08-29 00:00:00.000	1779.20	2614.50
21	10725	2007-10-31 00:00:00.000	287.80	2377.00
23	10408	2007-01-08 00:00:00.000	1622.40	1622.40
23	10480	2007-03-20 00:00:00.000	756.00	2378.40
23	10634	2007-08-15 00:00:00.000	4985.50	7363.90
23	10763	2007-12-03 00:00:00.000	616.00	6357.50
23	10789	2007-12-22 00:00:00.000	3687.00	9288.50
24	10264	2006-07-24 00:00:00.000	695.63	695.63
24	10327	2006-10-11 00:00:00.000	1810.00	2505.63
24	10378	2006-12-10 00:00:00.000	103.20	2608.83
24	10434	2007-02-03 00:00:00.000	321.12	2234.32
24	10460	2007-02-28 00:00:00.000	176.10	600.42
24	10533	2007-05-12 00:00:00.000	2222.20	2719.42
24	10561	2007-06-06 00:00:00.000	2844.50	5242.80
24	10703	2007-10-14 00:00:00.000	2545.00	7611.70
24	10762	2007-12-02 00:00:00.000	4337.00	9726.50
24	10774	2007-12-11 00:00:00.000	868.75	7750.75
24	10824	2008-01-09 00:00:00.000	250.80	5456.55
24	10880	2008-02-10 00:00:00.000	1500.00	2619.55
24	10902	2008-02-23 00:00:00.000	863.43	2614.23
24	10955	2008-03-17 00:00:00.000	74.40	2437.83
24	10977	2008-03-26 00:00:00.000	2233.00	3170.83
24	10980	2008-03-27 00:00:00.000	248.00	2555.40
24	10993	2008-04-01 00:00:00.000	4895.44	7376.44
24	11001	2008-04-06 00:00:00.000	2769.00	7912.44
24	11050	2008-04-27 00:00:00.000	810.00	8474.44
25	10267	2006-07-29 00:00:00.000	3536.60	3536.60
25	10337	2006-10-24 00:00:00.000	2467.00	6003.60
25	10342	2006-10-30 00:00:00.000	1840.64	7844.24
25	10396	2006-12-27 00:00:00.000	1903.80	6211.44
25	10488	2007-03-27 00:00:00.000	1512.00	5256.44
25	10560	2007-06-06 00:00:00.000	1072.43	4488.23
25	10623	2007-08-07 00:00:00.000	1336.95	3921.38
25	10653	2007-09-02 00:00:00.000	1083.15	3492.53
25	10670	2007-09-16 00:00:00.000	2301.75	4721.85
25	10675	2007-09-19 00:00:00.000	1423.00	4807.90
25	10717	2007-10-24 00:00:00.000	1270.75	4995.50
25	10791	2007-12-23 00:00:00.000	1829.76	4523.51
25	10859	2008-01-29 00:00:00.000	1078.69	4179.20
25	10929	2008-03-05 00:00:00.000	1174.75	4083.20
25	11012	2008-04-09 00:00:00.000	2825.30	5078.74
26	10671	2007-09-17 00:00:00.000	920.10	920.10
26	10860	2008-01-29 00:00:00.000	519.00	1439.10
26	10971	2008-03-24 00:00:00.000	1733.06	3172.16
27	10422	2007-01-22 00:00:00.000	49.80	49.80
27	10710	2007-10-20 00:00:00.000	93.50	143.30
27	10753	2007-11-25 00:00:00.000	88.00	231.30
27	10807	2007-12-31 00:00:00.000	18.40	199.90
27	11026	2008-04-15 00:00:00.000	1030.00	1136.40
27	11060	2008-04-30 00:00:00.000	266.00	1314.40
28	10328	2006-10-14 00:00:00.000	1168.00	1168.00
28	10352	2006-11-12 00:00:00.000	136.30	1304.30
28	10464	2007-03-04 00:00:00.000	1609.28	2913.58
28	10491	2007-03-31 00:00:00.000	259.51	2005.09
28	10551	2007-05-28 00:00:00.000	1677.30	3546.09
28	10604	2007-07-18 00:00:00.000	230.85	2167.66
28	10664	2007-09-10 00:00:00.000	1288.39	3196.54
28	10963	2008-03-19 00:00:00.000	57.80	1577.04
29	10366	2006-11-28 00:00:00.000	136.00	136.00
29	10426	2007-01-27 00:00:00.000	338.20	474.20
29	10568	2007-06-13 00:00:00.000	155.00	629.20
29	10887	2008-02-13 00:00:00.000	70.00	563.20
29	10928	2008-03-05 00:00:00.000	137.50	362.50
30	10303	2006-09-11 00:00:00.000	1117.80	1117.80
30	10550	2007-05-28 00:00:00.000	683.30	1801.10
30	10629	2007-08-12 00:00:00.000	2775.05	4576.15
30	10872	2008-02-05 00:00:00.000	2058.46	5516.81
30	10874	2008-02-06 00:00:00.000	310.00	5143.51
30	10888	2008-02-16 00:00:00.000	605.00	2973.46
30	10911	2008-02-26 00:00:00.000	858.00	1773.00
30	10948	2008-03-13 00:00:00.000	2362.25	3825.25
30	11009	2008-04-08 00:00:00.000	616.50	3836.75
30	11037	2008-04-21 00:00:00.000	60.00	3038.75
31	10423	2007-01-23 00:00:00.000	1020.00	1020.00
31	10652	2007-09-01 00:00:00.000	318.84	1338.84
31	10685	2007-09-29 00:00:00.000	801.10	2139.94
31	10709	2007-10-17 00:00:00.000	3424.00	4543.94
31	10734	2007-11-07 00:00:00.000	1498.35	5723.45
31	10777	2007-12-15 00:00:00.000	224.00	5146.35
31	10790	2007-12-22 00:00:00.000	722.50	2444.85
31	10959	2008-03-18 00:00:00.000	131.75	1078.25
31	11049	2008-04-24 00:00:00.000	273.60	1127.85
32	10528	2007-05-06 00:00:00.000	392.20	392.20
32	10589	2007-07-04 00:00:00.000	72.00	464.20
32	10616	2007-07-31 00:00:00.000	4807.00	5271.20
32	10617	2007-07-31 00:00:00.000	1402.50	6281.50
32	10656	2007-09-04 00:00:00.000	604.22	6813.72
32	10681	2007-09-25 00:00:00.000	1287.40	3294.12
32	10816	2008-01-06 00:00:00.000	8446.45	10338.07
32	10936	2008-03-09 00:00:00.000	456.00	10189.85
32	11006	2008-04-07 00:00:00.000	329.69	9232.14
32	11040	2008-04-22 00:00:00.000	200.00	985.69
32	11061	2008-04-30 00:00:00.000	510.00	1039.69
33	10268	2006-07-30 00:00:00.000	1101.20	1101.20
33	10785	2007-12-18 00:00:00.000	387.50	1488.70
34	10250	2006-07-08 00:00:00.000	1552.60	1552.60
34	10253	2006-07-10 00:00:00.000	1444.80	2997.40
34	10541	2007-05-19 00:00:00.000	1946.52	4943.92
34	10645	2007-08-26 00:00:00.000	1535.00	4926.32
34	10690	2007-10-02 00:00:00.000	862.50	4344.02
34	10770	2007-12-09 00:00:00.000	236.25	2633.75
34	10783	2007-12-18 00:00:00.000	1442.50	2541.25
34	10886	2008-02-13 00:00:00.000	3127.50	4806.25
34	10903	2008-02-24 00:00:00.000	932.05	5502.05
34	10922	2008-03-03 00:00:00.000	742.50	4802.05
34	10925	2008-03-04 00:00:00.000	475.15	2149.70
34	10981	2008-03-27 00:00:00.000	15810.00	17027.65
34	11022	2008-04-14 00:00:00.000	1402.00	17687.15
34	11052	2008-04-27 00:00:00.000	1332.00	18544.00
35	10257	2006-07-16 00:00:00.000	1119.90	1119.90
35	10395	2006-12-26 00:00:00.000	2122.92	3242.82
35	10476	2007-03-17 00:00:00.000	180.48	3423.30
35	10486	2007-03-26 00:00:00.000	1272.00	3575.40
35	10490	2007-03-31 00:00:00.000	3163.20	4615.68
35	10498	2007-04-07 00:00:00.000	575.00	5010.20
35	10552	2007-05-29 00:00:00.000	880.50	4618.70
35	10601	2007-07-16 00:00:00.000	2285.00	3740.50
35	10613	2007-07-29 00:00:00.000	353.20	3518.70
35	10641	2007-08-22 00:00:00.000	2054.00	4692.20
35	10705	2007-10-15 00:00:00.000	378.00	2785.20
35	10796	2007-12-25 00:00:00.000	2341.36	4773.36
35	10863	2008-02-02 00:00:00.000	441.15	3160.51
35	10901	2008-02-23 00:00:00.000	934.50	3717.01
35	10957	2008-03-18 00:00:00.000	1762.70	3138.35
35	10960	2008-03-19 00:00:00.000	265.35	2962.55
35	10976	2008-03-25 00:00:00.000	912.00	2940.05
35	11055	2008-04-28 00:00:00.000	1727.50	2904.85
36	10375	2006-12-06 00:00:00.000	338.00	338.00
36	10394	2006-12-25 00:00:00.000	442.00	780.00
36	10415	2007-01-15 00:00:00.000	102.40	882.40
36	10600	2007-07-16 00:00:00.000	479.80	1024.20
36	10660	2007-09-08 00:00:00.000	1701.00	2283.20
37	10298	2006-09-05 00:00:00.000	2645.00	2645.00
37	10309	2006-09-19 00:00:00.000	1762.00	4407.00
37	10335	2006-10-22 00:00:00.000	2036.16	6443.16
37	10373	2006-12-05 00:00:00.000	1366.40	5164.56
37	10380	2006-12-12 00:00:00.000	1313.82	4716.38
37	10429	2007-01-29 00:00:00.000	1441.38	4121.60
37	10503	2007-04-11 00:00:00.000	2048.50	4803.70
37	10516	2007-04-24 00:00:00.000	2381.05	5870.93
37	10567	2007-06-12 00:00:00.000	2519.00	6948.55
37	10646	2007-08-27 00:00:00.000	1446.00	6346.05
37	10661	2007-09-09 00:00:00.000	562.60	4527.60
37	10687	2007-09-30 00:00:00.000	4960.90	6969.50
37	10701	2007-10-13 00:00:00.000	2864.50	8388.00
37	10712	2007-10-21 00:00:00.000	1233.48	9058.88
37	10736	2007-11-11 00:00:00.000	997.00	5094.98
37	10897	2008-02-19 00:00:00.000	10835.24	13065.72
37	10912	2008-02-26 00:00:00.000	6200.55	18032.79
37	10985	2008-03-30 00:00:00.000	2023.38	19059.17
37	11063	2008-04-30 00:00:00.000	1342.95	9566.88
38	10315	2006-09-26 00:00:00.000	516.80	516.80
38	10318	2006-10-01 00:00:00.000	240.40	757.20
38	10321	2006-10-03 00:00:00.000	144.00	901.20
38	10473	2007-03-13 00:00:00.000	230.40	614.80
38	10621	2007-08-05 00:00:00.000	758.50	1132.90
38	10674	2007-09-18 00:00:00.000	45.00	1033.90
38	10749	2007-11-20 00:00:00.000	1080.00	1883.50
38	10798	2007-12-26 00:00:00.000	446.60	1571.60
38	10829	2008-01-13 00:00:00.000	1764.00	3290.60
38	10933	2008-03-06 00:00:00.000	920.60	3131.20
39	10323	2006-10-07 00:00:00.000	164.40	164.40
39	10325	2006-10-09 00:00:00.000	1497.00	1661.40
39	10456	2007-02-25 00:00:00.000	557.60	2219.00
39	10457	2007-02-25 00:00:00.000	1584.00	3638.60
39	10468	2007-03-07 00:00:00.000	717.60	2859.20
39	10506	2007-04-15 00:00:00.000	415.80	2717.40
39	10542	2007-05-20 00:00:00.000	469.11	1602.51
39	10630	2007-08-13 00:00:00.000	903.60	1788.51
39	10718	2007-10-27 00:00:00.000	3463.00	4835.71
39	10799	2007-12-26 00:00:00.000	1553.50	5920.10
39	10817	2008-01-06 00:00:00.000	10952.85	15969.35
39	10849	2008-01-23 00:00:00.000	967.82	13474.17
39	10893	2008-02-18 00:00:00.000	5502.11	17422.78
39	11028	2008-04-16 00:00:00.000	2160.00	8629.93
40	10858	2008-01-29 00:00:00.000	649.00	649.00
40	10927	2008-03-05 00:00:00.000	800.00	1449.00
40	10972	2008-03-24 00:00:00.000	251.50	1700.50
40	10973	2008-03-24 00:00:00.000	291.55	1343.05
41	10350	2006-11-11 00:00:00.000	642.06	642.06
41	10358	2006-11-20 00:00:00.000	429.40	1071.46
41	10371	2006-12-03 00:00:00.000	72.96	1144.42
41	10413	2007-01-14 00:00:00.000	2123.20	2625.56
41	10425	2007-01-24 00:00:00.000	360.00	2556.16
41	10454	2007-02-21 00:00:00.000	331.20	2814.40
41	10493	2007-04-02 00:00:00.000	608.40	1299.60
41	10500	2007-04-09 00:00:00.000	523.26	1462.86
41	10610	2007-07-25 00:00:00.000	299.25	1430.91
41	10631	2007-08-14 00:00:00.000	55.80	878.31
41	10787	2007-12-19 00:00:00.000	2622.76	2977.81
41	10832	2008-01-14 00:00:00.000	475.11	3153.67
41	10923	2008-03-03 00:00:00.000	748.80	3846.67
41	11051	2008-04-27 00:00:00.000	36.00	1259.91
42	10495	2007-04-03 00:00:00.000	278.00	278.00
42	10620	2007-08-05 00:00:00.000	57.50	335.50
42	10810	2008-01-01 00:00:00.000	187.00	522.50
43	10482	2007-03-21 00:00:00.000	147.00	147.00
43	10545	2007-05-22 00:00:00.000	210.00	357.00
44	10279	2006-08-13 00:00:00.000	351.00	351.00
44	10284	2006-08-19 00:00:00.000	1170.38	1521.38
44	10343	2006-10-31 00:00:00.000	1584.00	3105.38
44	10497	2007-04-04 00:00:00.000	1380.60	4134.98
44	10522	2007-04-30 00:00:00.000	2318.24	5282.84
44	10534	2007-05-12 00:00:00.000	465.70	4164.54
44	10536	2007-05-14 00:00:00.000	1645.00	4428.94
44	10557	2007-06-03 00:00:00.000	1152.50	3263.20
44	10592	2007-07-08 00:00:00.000	516.47	3313.97
44	10593	2007-07-09 00:00:00.000	1994.40	3663.37
44	10772	2007-12-10 00:00:00.000	3603.22	6114.09
44	10862	2008-01-30 00:00:00.000	581.00	6178.62
44	10891	2008-02-17 00:00:00.000	368.93	4553.15
44	10934	2008-03-09 00:00:00.000	500.00	1449.93
44	11070	2008-05-05 00:00:00.000	1629.98	2498.91
45	10579	2007-06-25 00:00:00.000	317.75	317.75
45	10719	2007-10-27 00:00:00.000	844.25	1162.00
45	10735	2007-11-10 00:00:00.000	536.40	1698.40
45	10884	2008-02-12 00:00:00.000	1378.07	2758.72
46	10283	2006-08-16 00:00:00.000	1414.80	1414.80
46	10296	2006-09-03 00:00:00.000	1050.60	2465.40
46	10330	2006-10-16 00:00:00.000	1649.00	4114.40
46	10357	2006-11-19 00:00:00.000	1167.68	3867.28
46	10381	2006-12-12 00:00:00.000	112.00	2928.68
46	10461	2007-02-28 00:00:00.000	1538.70	2818.38
46	10499	2007-04-08 00:00:00.000	1412.00	3062.70
46	10543	2007-05-21 00:00:00.000	1504.50	4455.20
46	10780	2007-12-16 00:00:00.000	720.00	3636.50
46	10823	2008-01-09 00:00:00.000	2826.00	5050.50
46	10899	2008-02-20 00:00:00.000	122.40	3668.40
46	10997	2008-04-03 00:00:00.000	1885.00	4833.40
46	11065	2008-05-01 00:00:00.000	189.42	2196.82
46	11071	2008-05-05 00:00:00.000	484.50	2558.92
47	10405	2007-01-06 00:00:00.000	400.00	400.00
47	10485	2007-03-25 00:00:00.000	1584.00	1984.00
47	10638	2007-08-20 00:00:00.000	2720.05	4704.05
47	10697	2007-10-08 00:00:00.000	805.43	5109.48
47	10729	2007-11-04 00:00:00.000	1850.00	5375.48
47	10811	2008-01-02 00:00:00.000	852.00	3507.43
47	10838	2008-01-19 00:00:00.000	1938.38	4640.38
47	10840	2008-01-19 00:00:00.000	211.20	3001.58
47	10919	2008-03-02 00:00:00.000	1122.80	3272.38
47	10954	2008-03-17 00:00:00.000	1659.54	2993.54
47	11014	2008-04-10 00:00:00.000	243.18	3025.52
47	11039	2008-04-21 00:00:00.000	3090.00	4992.72
48	10307	2006-09-17 00:00:00.000	424.00	424.00
48	10317	2006-09-30 00:00:00.000	288.00	712.00
48	10544	2007-05-21 00:00:00.000	417.20	1129.20
48	10662	2007-09-09 00:00:00.000	125.00	830.20
48	10665	2007-09-11 00:00:00.000	1295.00	1837.20
48	10867	2008-02-03 00:00:00.000	98.40	1518.40
48	10883	2008-02-12 00:00:00.000	36.00	1429.40
48	11018	2008-04-13 00:00:00.000	1575.00	1709.40
49	10275	2006-08-07 00:00:00.000	291.84	291.84
49	10300	2006-09-09 00:00:00.000	608.00	899.84
49	10404	2007-01-03 00:00:00.000	1591.25	2491.09
49	10467	2007-03-06 00:00:00.000	235.20	2434.45
49	10635	2007-08-18 00:00:00.000	1326.23	3152.68
49	10754	2007-11-25 00:00:00.000	55.20	1616.63
49	10784	2007-12-18 00:00:00.000	1488.00	2869.43
49	10818	2008-01-07 00:00:00.000	833.00	2376.20
49	10939	2008-03-10 00:00:00.000	637.50	2958.50
49	10950	2008-03-16 00:00:00.000	110.00	1580.50
50	10529	2007-05-07 00:00:00.000	946.00	946.00
50	10649	2007-08-28 00:00:00.000	1434.00	2380.00
50	10760	2007-12-01 00:00:00.000	2917.00	5297.00
50	10892	2008-02-17 00:00:00.000	2090.00	6441.00
50	10896	2008-02-19 00:00:00.000	750.50	5757.50
50	10978	2008-03-26 00:00:00.000	1303.20	4143.70
50	11004	2008-04-07 00:00:00.000	295.38	2349.08
51	10332	2006-10-17 00:00:00.000	1786.88	1786.88
51	10339	2006-10-28 00:00:00.000	3354.00	5140.88
51	10376	2006-12-09 00:00:00.000	399.00	5539.88
51	10424	2007-01-23 00:00:00.000	9194.56	12947.56
51	10439	2007-02-07 00:00:00.000	1078.00	10671.56
51	10505	2007-04-14 00:00:00.000	147.90	10420.46
51	10565	2007-06-11 00:00:00.000	639.90	1865.80
51	10570	2007-06-17 00:00:00.000	2465.25	3253.05
51	10590	2007-07-07 00:00:00.000	1101.00	4206.15
51	10605	2007-07-21 00:00:00.000	4109.70	7675.95
51	10618	2007-08-01 00:00:00.000	2697.50	7908.20
51	10619	2007-08-04 00:00:00.000	1260.00	8067.20
51	10724	2007-10-30 00:00:00.000	638.50	4596.00
52	10277	2006-08-09 00:00:00.000	1200.80	1200.80
52	10575	2007-06-20 00:00:00.000	2147.40	3348.20
52	10699	2007-10-09 00:00:00.000	114.00	3462.20
52	10779	2007-12-16 00:00:00.000	1335.00	3596.40
52	10945	2008-03-12 00:00:00.000	245.00	1694.00
53	10517	2007-04-24 00:00:00.000	352.00	352.00
53	10752	2007-11-24 00:00:00.000	252.00	604.00
53	11057	2008-04-29 00:00:00.000	45.00	649.00
54	10409	2007-01-09 00:00:00.000	319.20	319.20
54	10531	2007-05-08 00:00:00.000	110.00	429.20
54	10898	2008-02-20 00:00:00.000	30.00	459.20
54	10958	2008-03-18 00:00:00.000	781.00	921.00
54	10986	2008-03-30 00:00:00.000	2220.00	3031.00
55	10305	2006-09-13 00:00:00.000	3741.30	3741.30
55	10338	2006-10-25 00:00:00.000	934.50	4675.80
55	10441	2007-02-10 00:00:00.000	1755.00	6430.80
55	10594	2007-07-09 00:00:00.000	565.50	3255.00
55	10680	2007-09-24 00:00:00.000	1261.88	3582.38
55	10706	2007-10-16 00:00:00.000	1893.00	3720.38
55	10808	2008-01-01 00:00:00.000	1411.00	4565.88
55	10855	2008-01-27 00:00:00.000	2227.89	5531.89
55	10965	2008-03-20 00:00:00.000	848.00	4486.89
55	11034	2008-04-20 00:00:00.000	539.40	3615.29
56	10260	2006-07-19 00:00:00.000	1504.65	1504.65
56	10407	2007-01-07 00:00:00.000	1194.00	2698.65
56	10508	2007-04-16 00:00:00.000	240.00	2938.65
56	10554	2007-05-30 00:00:00.000	1728.53	3162.53
56	10580	2007-06-26 00:00:00.000	1013.75	2982.28
56	10684	2007-09-26 00:00:00.000	1768.00	4510.28
56	10766	2007-12-05 00:00:00.000	2310.00	5091.75
56	10833	2008-01-15 00:00:00.000	906.93	4984.93
56	10999	2008-04-03 00:00:00.000	1197.95	4414.88
56	11020	2008-04-14 00:00:00.000	632.40	2737.28
58	10322	2006-10-04 00:00:00.000	112.00	112.00
58	10354	2006-11-14 00:00:00.000	568.80	680.80
58	10474	2007-03-13 00:00:00.000	1249.10	1929.90
58	10502	2007-04-10 00:00:00.000	816.30	2634.20
58	10995	2008-04-02 00:00:00.000	1196.00	3261.40
58	11073	2008-05-05 00:00:00.000	300.00	2312.30
59	10353	2006-11-13 00:00:00.000	8593.28	8593.28
59	10392	2006-12-24 00:00:00.000	1440.00	10033.28
59	10427	2007-01-27 00:00:00.000	651.00	10684.28
59	10489	2007-03-28 00:00:00.000	439.20	2530.20
59	10530	2007-05-08 00:00:00.000	4180.00	5270.20
59	10597	2007-07-11 00:00:00.000	718.08	5337.28
59	10686	2007-09-30 00:00:00.000	1404.45	6302.53
59	10747	2007-11-19 00:00:00.000	1912.85	4035.38
59	10844	2008-01-21 00:00:00.000	735.00	4052.30
59	11053	2008-04-27 00:00:00.000	3055.00	5702.85
60	10336	2006-10-23 00:00:00.000	285.12	285.12
60	10397	2006-12-27 00:00:00.000	716.72	1001.84
60	10433	2007-02-03 00:00:00.000	851.20	1853.04
60	10477	2007-03-17 00:00:00.000	558.00	2125.92
60	11007	2008-04-08 00:00:00.000	2633.90	4043.10
61	10261	2006-07-19 00:00:00.000	448.00	448.00
61	10291	2006-08-27 00:00:00.000	497.52	945.52
61	10379	2006-12-11 00:00:00.000	863.28	1808.80
61	10421	2007-01-21 00:00:00.000	1194.27	2555.07
61	10587	2007-07-02 00:00:00.000	807.38	2864.93
61	10647	2007-08-27 00:00:00.000	636.00	2637.65
61	10720	2007-10-28 00:00:00.000	550.00	1993.38
61	10794	2007-12-24 00:00:00.000	314.76	1500.76
61	10989	2008-03-31 00:00:00.000	1353.60	2218.36
62	10372	2006-12-04 00:00:00.000	9210.90	9210.90
62	10406	2007-01-07 00:00:00.000	1830.78	11041.68
62	10487	2007-03-26 00:00:00.000	889.70	11931.38
62	10637	2007-08-19 00:00:00.000	2761.94	5482.42
62	10659	2007-09-05 00:00:00.000	1227.02	4878.66
62	10704	2007-10-14 00:00:00.000	595.50	4584.46
62	10728	2007-11-04 00:00:00.000	1296.75	3119.27
62	10786	2007-12-19 00:00:00.000	1531.08	3423.33
62	10868	2008-02-04 00:00:00.000	1920.60	4748.43
62	10913	2008-02-26 00:00:00.000	768.75	4220.43
62	10914	2008-02-27 00:00:00.000	537.50	3226.85
62	10961	2008-03-19 00:00:00.000	1119.90	2426.15
62	11068	2008-05-04 00:00:00.000	2027.08	3684.48
63	10273	2006-08-05 00:00:00.000	2037.28	2037.28
63	10285	2006-08-20 00:00:00.000	1743.36	3780.64
63	10286	2006-08-21 00:00:00.000	3016.00	6796.64
63	10313	2006-09-24 00:00:00.000	182.40	4941.76
63	10345	2006-11-04 00:00:00.000	2924.80	6123.20
63	10361	2006-11-22 00:00:00.000	2046.24	5153.44
63	10418	2007-01-17 00:00:00.000	1814.80	6785.84
63	10451	2007-02-19 00:00:00.000	3849.66	7710.70
63	10515	2007-04-23 00:00:00.000	9921.30	15585.76
63	10527	2007-05-05 00:00:00.000	1503.00	15273.96
63	10540	2007-05-19 00:00:00.000	10191.70	21616.00
63	10549	2007-05-27 00:00:00.000	3554.28	15248.98
63	10588	2007-07-03 00:00:00.000	3120.00	16865.98
63	10658	2007-09-05 00:00:00.000	4464.60	11138.88
63	10691	2007-10-03 00:00:00.000	10164.80	17749.40
63	10694	2007-10-06 00:00:00.000	4825.00	19454.40
63	10721	2007-10-29 00:00:00.000	923.88	15913.68
63	10745	2007-11-18 00:00:00.000	4529.80	10278.68
63	10765	2007-12-04 00:00:00.000	1515.60	6969.28
63	10788	2007-12-22 00:00:00.000	731.50	6776.90
63	10845	2008-01-21 00:00:00.000	3812.70	6059.80
63	10865	2008-02-02 00:00:00.000	16387.50	20931.70
63	10878	2008-02-10 00:00:00.000	1539.00	21739.20
63	10938	2008-03-10 00:00:00.000	2731.88	20658.38
63	10962	2008-03-19 00:00:00.000	3584.00	7854.88
63	10991	2008-04-01 00:00:00.000	2296.00	8611.88
63	10996	2008-04-02 00:00:00.000	560.00	6440.00
63	11021	2008-04-14 00:00:00.000	6306.24	9162.24
64	10448	2007-02-17 00:00:00.000	443.40	443.40
64	10716	2007-10-24 00:00:00.000	706.00	1149.40
64	10828	2008-01-13 00:00:00.000	932.00	2081.40
64	10916	2008-02-27 00:00:00.000	686.70	2324.70
64	11019	2008-04-13 00:00:00.000	76.00	1694.70
65	10262	2006-07-22 00:00:00.000	584.00	584.00
65	10272	2006-08-02 00:00:00.000	1456.00	2040.00
65	10294	2006-08-30 00:00:00.000	1887.60	3927.60
65	10314	2006-09-25 00:00:00.000	2094.30	5437.90
65	10316	2006-09-27 00:00:00.000	2835.00	6816.90
65	10346	2006-11-05 00:00:00.000	1618.88	6548.18
65	10401	2007-01-01 00:00:00.000	3868.60	8322.48
65	10479	2007-03-19 00:00:00.000	10495.60	15983.08
65	10564	2007-06-10 00:00:00.000	1234.05	15598.25
65	10569	2007-06-16 00:00:00.000	890.00	12619.65
65	10598	2007-07-14 00:00:00.000	2388.50	4512.55
65	10761	2007-12-02 00:00:00.000	507.00	3785.50
65	10820	2008-01-07 00:00:00.000	1140.00	4035.50
65	10852	2008-01-26 00:00:00.000	2984.00	4631.00
65	10889	2008-02-16 00:00:00.000	11380.00	15504.00
65	10988	2008-03-31 00:00:00.000	3574.80	17938.80
65	11000	2008-04-06 00:00:00.000	903.75	15858.55
65	11077	2008-05-06 00:00:00.000	1255.72	5734.27
66	10288	2006-08-23 00:00:00.000	80.10	80.10
66	10428	2007-01-28 00:00:00.000	192.00	272.10
66	10443	2007-02-12 00:00:00.000	517.44	789.54
66	10562	2007-06-09 00:00:00.000	488.70	1198.14
66	10586	2007-07-02 00:00:00.000	23.80	1029.94
66	10655	2007-09-03 00:00:00.000	154.40	666.90
66	10727	2007-11-03 00:00:00.000	1624.50	1802.70
66	10812	2008-01-02 00:00:00.000	1692.80	3471.70
66	10908	2008-02-26 00:00:00.000	663.10	3980.40
66	10942	2008-03-11 00:00:00.000	560.00	2915.90
66	11010	2008-04-09 00:00:00.000	645.00	1868.10
66	11062	2008-04-30 00:00:00.000	406.40	1611.40
67	10287	2006-08-22 00:00:00.000	819.00	819.00
67	10299	2006-09-06 00:00:00.000	349.50	1168.50
67	10447	2007-02-14 00:00:00.000	914.40	2082.90
67	10481	2007-03-20 00:00:00.000	1472.00	2735.90
67	10563	2007-06-10 00:00:00.000	965.00	3351.40
67	10622	2007-08-06 00:00:00.000	560.00	2997.00
67	10648	2007-08-28 00:00:00.000	372.38	1897.38
67	10813	2008-01-05 00:00:00.000	602.40	1534.78
67	10851	2008-01-26 00:00:00.000	2603.00	3577.78
67	10877	2008-02-09 00:00:00.000	1955.13	5160.53
67	11059	2008-04-29 00:00:00.000	1838.00	6396.13
68	10255	2006-07-12 00:00:00.000	2490.50	2490.50
68	10419	2007-01-20 00:00:00.000	2097.60	4588.10
68	10537	2007-05-14 00:00:00.000	1823.80	6411.90
68	10666	2007-09-12 00:00:00.000	4666.94	8588.34
68	10751	2007-11-24 00:00:00.000	1631.48	8122.22
68	10758	2007-11-28 00:00:00.000	1644.60	7943.02
68	10931	2008-03-06 00:00:00.000	799.20	4075.28
68	10951	2008-03-16 00:00:00.000	458.76	2902.56
68	11033	2008-04-17 00:00:00.000	3232.80	4490.76
68	11075	2008-05-06 00:00:00.000	498.10	4189.66
69	10281	2006-08-14 00:00:00.000	86.50	86.50
69	10282	2006-08-15 00:00:00.000	155.40	241.90
69	10306	2006-09-16 00:00:00.000	498.50	740.40
69	10917	2008-03-02 00:00:00.000	365.89	1019.79
69	11013	2008-04-09 00:00:00.000	361.00	1225.39
70	10387	2006-12-18 00:00:00.000	1058.40	1058.40
70	10520	2007-04-29 00:00:00.000	200.00	1258.40
70	10639	2007-08-20 00:00:00.000	500.00	1758.40
70	10831	2008-01-14 00:00:00.000	2684.40	3384.40
70	10909	2008-02-26 00:00:00.000	670.00	3854.40
70	11015	2008-04-10 00:00:00.000	622.35	3976.75
71	10324	2006-10-08 00:00:00.000	5275.72	5275.72
71	10393	2006-12-25 00:00:00.000	2556.95	7832.67
71	10398	2006-12-30 00:00:00.000	2505.60	10338.27
71	10440	2007-02-10 00:00:00.000	4924.14	9986.69
71	10452	2007-02-20 00:00:00.000	2018.50	9448.24
71	10510	2007-04-18 00:00:00.000	4707.54	11650.18
71	10555	2007-06-02 00:00:00.000	2944.40	9670.44
71	10603	2007-07-18 00:00:00.000	1483.00	9134.94
71	10607	2007-07-22 00:00:00.000	6475.40	10902.80
71	10612	2007-07-28 00:00:00.000	6375.00	14333.40
71	10627	2007-08-11 00:00:00.000	1185.75	14036.15
71	10657	2007-09-04 00:00:00.000	4371.60	11932.35
71	10678	2007-09-23 00:00:00.000	5256.50	10813.85
71	10700	2007-10-10 00:00:00.000	1638.40	11266.50
71	10711	2007-10-21 00:00:00.000	4451.70	11346.60
71	10713	2007-10-22 00:00:00.000	2827.90	8918.00
71	10714	2007-10-22 00:00:00.000	2205.75	9485.35
71	10722	2007-10-29 00:00:00.000	1570.00	6603.65
71	10748	2007-11-20 00:00:00.000	2196.00	5971.75
71	10757	2007-11-27 00:00:00.000	3082.00	6848.00
71	10815	2008-01-05 00:00:00.000	40.00	5318.00
71	10847	2008-01-22 00:00:00.000	4931.92	8053.92
71	10882	2008-02-11 00:00:00.000	892.64	5864.56
71	10894	2008-02-18 00:00:00.000	2753.10	8577.66
71	10941	2008-03-11 00:00:00.000	4011.75	7657.49
71	10983	2008-03-27 00:00:00.000	720.90	7485.75
71	10984	2008-03-30 00:00:00.000	1809.75	6542.40
71	11002	2008-04-06 00:00:00.000	1811.10	4341.75
71	11030	2008-04-17 00:00:00.000	12615.05	16235.90
71	11031	2008-04-17 00:00:00.000	2393.50	16819.65
71	11064	2008-05-01 00:00:00.000	4330.40	19338.95
72	10359	2006-11-21 00:00:00.000	3471.68	3471.68
72	10377	2006-12-09 00:00:00.000	863.60	4335.28
72	10388	2006-12-19 00:00:00.000	1228.80	5564.08
72	10472	2007-03-12 00:00:00.000	1036.80	3129.20
72	10523	2007-05-01 00:00:00.000	2444.31	4709.91
72	10547	2007-05-23 00:00:00.000	1792.80	5273.91
72	10800	2007-12-26 00:00:00.000	1468.94	5706.05
72	10804	2007-12-30 00:00:00.000	2278.40	5540.14
72	10869	2008-02-04 00:00:00.000	1630.00	5377.34
73	10341	2006-10-29 00:00:00.000	352.60	352.60
73	10417	2007-01-16 00:00:00.000	11188.40	11541.00
73	10556	2007-06-03 00:00:00.000	835.20	12376.20
73	10642	2007-08-22 00:00:00.000	696.00	12719.60
73	10669	2007-09-15 00:00:00.000	570.00	2101.20
73	10802	2007-12-29 00:00:00.000	2942.81	4208.81
73	11074	2008-05-06 00:00:00.000	232.09	3744.90
74	10738	2007-11-12 00:00:00.000	52.35	52.35
74	10907	2008-02-25 00:00:00.000	108.50	160.85
74	10964	2008-03-20 00:00:00.000	2052.50	2213.35
74	11043	2008-04-22 00:00:00.000	210.00	2371.00
75	10271	2006-08-01 00:00:00.000	48.00	48.00
75	10329	2006-10-15 00:00:00.000	4578.43	4626.43
75	10349	2006-11-08 00:00:00.000	141.60	4768.03
75	10369	2006-12-02 00:00:00.000	2390.40	7110.43
75	10385	2006-12-17 00:00:00.000	691.20	3223.20
75	10432	2007-01-31 00:00:00.000	485.00	3566.60
75	10756	2007-11-27 00:00:00.000	1990.00	3166.20
75	10821	2008-01-08 00:00:00.000	678.00	3153.00
75	10974	2008-03-25 00:00:00.000	439.00	3107.00
76	10252	2006-07-09 00:00:00.000	3597.90	3597.90
76	10302	2006-09-10 00:00:00.000	2708.80	6306.70
76	10458	2007-02-26 00:00:00.000	3891.00	10197.70
76	10463	2007-03-04 00:00:00.000	713.30	7313.10
76	10475	2007-03-14 00:00:00.000	1505.18	6109.48
76	10767	2007-12-05 00:00:00.000	28.00	2246.48
76	10841	2008-01-20 00:00:00.000	4581.00	6114.18
76	10846	2008-01-22 00:00:00.000	1112.00	5721.00
76	10885	2008-02-12 00:00:00.000	1209.00	6902.00
76	10930	2008-03-06 00:00:00.000	2255.50	4576.50
76	11035	2008-04-20 00:00:00.000	1754.50	5219.00
76	11038	2008-04-21 00:00:00.000	732.60	4742.60
77	10310	2006-09-20 00:00:00.000	336.00	336.00
77	10708	2007-10-17 00:00:00.000	180.40	516.40
77	10805	2007-12-30 00:00:00.000	2775.00	3291.40
77	10992	2008-04-01 00:00:00.000	69.60	3025.00
78	10624	2007-08-07 00:00:00.000	1393.24	1393.24
78	10775	2007-12-12 00:00:00.000	228.00	1621.24
78	11003	2008-04-06 00:00:00.000	326.00	1947.24
79	10249	2006-07-05 00:00:00.000	1863.40	1863.40
79	10438	2007-02-06 00:00:00.000	454.00	2317.40
79	10446	2007-02-14 00:00:00.000	246.24	2563.64
79	10548	2007-05-26 00:00:00.000	240.10	940.34
79	10608	2007-07-23 00:00:00.000	1064.00	1550.34
79	10967	2008-03-23 00:00:00.000	910.40	2214.50
80	10276	2006-08-08 00:00:00.000	420.00	420.00
80	10293	2006-08-29 00:00:00.000	848.70	1268.70
80	10304	2006-09-12 00:00:00.000	954.40	2223.10
80	10319	2006-10-02 00:00:00.000	1191.20	2994.30
80	10518	2007-04-25 00:00:00.000	4150.05	6295.65
80	10576	2007-06-23 00:00:00.000	838.45	6179.70
80	10676	2007-09-22 00:00:00.000	534.85	5523.35
80	10842	2008-01-20 00:00:00.000	975.00	2348.30
80	10915	2008-02-27 00:00:00.000	539.50	2049.35
80	11069	2008-05-04 00:00:00.000	360.00	1874.50
81	10292	2006-08-28 00:00:00.000	1296.00	1296.00
81	10496	2007-04-04 00:00:00.000	190.00	1486.00
81	10606	2007-07-22 00:00:00.000	1130.40	2616.40
81	10830	2008-01-13 00:00:00.000	1974.00	3294.40
81	10834	2008-01-15 00:00:00.000	1432.71	4537.11
81	10839	2008-01-19 00:00:00.000	827.55	4234.26
82	10574	2007-06-19 00:00:00.000	764.30	764.30
82	10577	2007-06-23 00:00:00.000	569.00	1333.30
82	10822	2008-01-08 00:00:00.000	237.90	1571.20
83	10367	2006-11-28 00:00:00.000	834.20	834.20
83	10399	2006-12-31 00:00:00.000	1765.60	2599.80
83	10465	2007-03-05 00:00:00.000	2518.00	5117.80
83	10591	2007-07-07 00:00:00.000	812.50	5096.10
83	10602	2007-07-17 00:00:00.000	48.75	3379.25
83	10688	2007-10-01 00:00:00.000	3160.60	4021.85
83	10744	2007-11-17 00:00:00.000	736.00	3945.35
83	10769	2007-12-08 00:00:00.000	1684.28	5580.88
83	10921	2008-03-03 00:00:00.000	1936.00	4356.28
83	10946	2008-03-12 00:00:00.000	1407.50	5027.78
83	10994	2008-04-02 00:00:00.000	940.50	4284.00
84	10251	2006-07-08 00:00:00.000	654.06	654.06
84	10334	2006-10-21 00:00:00.000	144.80	798.86
84	10450	2007-02-19 00:00:00.000	425.12	1223.98
84	10459	2007-02-27 00:00:00.000	1659.20	2229.12
84	10478	2007-03-18 00:00:00.000	471.20	2555.52
84	10546	2007-05-23 00:00:00.000	2812.00	4942.40
84	10806	2007-12-31 00:00:00.000	439.60	3722.80
84	10814	2008-01-05 00:00:00.000	1788.45	5040.05
84	10843	2008-01-21 00:00:00.000	159.00	2387.05
84	10850	2008-01-23 00:00:00.000	629.00	2576.45
85	10248	2006-07-04 00:00:00.000	440.00	440.00
85	10274	2006-08-06 00:00:00.000	538.60	978.60
85	10295	2006-09-02 00:00:00.000	121.60	1100.20
85	10737	2007-11-11 00:00:00.000	139.80	800.00
85	10739	2007-11-12 00:00:00.000	240.00	501.40
86	10301	2006-09-09 00:00:00.000	755.00	755.00
86	10312	2006-09-23 00:00:00.000	1614.80	2369.80
86	10348	2006-11-07 00:00:00.000	363.60	2733.40
86	10356	2006-11-18 00:00:00.000	1106.40	3084.80
86	10513	2007-04-22 00:00:00.000	1942.00	3412.00
86	10632	2007-08-14 00:00:00.000	589.00	3637.40
86	10640	2007-08-21 00:00:00.000	708.75	3239.75
86	10651	2007-09-01 00:00:00.000	397.80	1695.55
86	10668	2007-09-15 00:00:00.000	625.28	1731.83
86	11046	2008-04-23 00:00:00.000	1485.80	2508.88
87	10266	2006-07-26 00:00:00.000	346.56	346.56
87	10270	2006-08-01 00:00:00.000	1376.00	1722.56
87	10320	2006-10-03 00:00:00.000	516.00	2238.56
87	10333	2006-10-18 00:00:00.000	877.20	2769.20
87	10412	2007-01-13 00:00:00.000	334.80	1728.00
87	10416	2007-01-16 00:00:00.000	720.00	1932.00
87	10437	2007-02-05 00:00:00.000	393.00	1447.80
87	10455	2007-02-24 00:00:00.000	2684.00	3797.00
87	10526	2007-05-05 00:00:00.000	1151.40	4228.40
87	10553	2007-05-30 00:00:00.000	1546.30	5381.70
87	10583	2007-06-30 00:00:00.000	2237.50	4935.20
87	10636	2007-08-19 00:00:00.000	629.50	4413.30
87	10750	2007-11-21 00:00:00.000	1590.56	4457.56
87	10781	2007-12-17 00:00:00.000	975.88	3195.94
87	11025	2008-04-15 00:00:00.000	270.00	2836.44
88	10256	2006-07-15 00:00:00.000	517.80	517.80
88	10420	2007-01-21 00:00:00.000	1707.84	2225.64
88	10585	2007-07-01 00:00:00.000	142.50	2368.14
88	10644	2007-08-25 00:00:00.000	1371.80	3222.14
88	10803	2007-12-30 00:00:00.000	1193.01	2707.31
88	10809	2008-01-01 00:00:00.000	140.00	2704.81
88	10900	2008-02-20 00:00:00.000	33.75	1366.76
88	10905	2008-02-24 00:00:00.000	342.00	515.75
88	10935	2008-03-09 00:00:00.000	619.50	995.25
89	10269	2006-07-31 00:00:00.000	642.20	642.20
89	10344	2006-11-01 00:00:00.000	2296.00	2938.20
89	10469	2007-03-10 00:00:00.000	956.68	3894.88
89	10483	2007-03-24 00:00:00.000	668.80	3921.48
89	10504	2007-04-11 00:00:00.000	1388.50	3013.98
89	10596	2007-07-11 00:00:00.000	1180.88	3238.18
89	10693	2007-10-06 00:00:00.000	2071.20	4640.58
89	10696	2007-10-08 00:00:00.000	996.00	4248.08
89	10723	2007-10-30 00:00:00.000	468.45	3535.65
89	10740	2007-11-13 00:00:00.000	1416.00	2880.45
89	10861	2008-01-30 00:00:00.000	3523.40	5407.85
89	10904	2008-02-24 00:00:00.000	1924.25	6863.65
89	11032	2008-04-17 00:00:00.000	8902.50	14350.15
89	11066	2008-05-01 00:00:00.000	928.75	11755.50
90	10615	2007-07-30 00:00:00.000	120.00	120.00
90	10673	2007-09-18 00:00:00.000	412.35	532.35
90	10695	2007-10-07 00:00:00.000	642.00	1174.35
90	10873	2008-02-06 00:00:00.000	336.80	1391.15
90	10879	2008-02-10 00:00:00.000	611.30	1590.10
90	10910	2008-02-26 00:00:00.000	452.90	1401.00
90	11005	2008-04-07 00:00:00.000	586.00	1650.20
91	10374	2006-12-05 00:00:00.000	459.00	459.00
91	10611	2007-07-25 00:00:00.000	808.00	1267.00
91	10792	2007-12-23 00:00:00.000	399.85	1666.85
91	10870	2008-02-04 00:00:00.000	160.00	1367.85
91	10906	2008-02-25 00:00:00.000	427.50	987.35
91	10998	2008-04-03 00:00:00.000	686.00	1273.50
91	11044	2008-04-23 00:00:00.000	591.60	1705.10

Open in new window


SELECT custid, orderid, orderdate, val,
SUM(val) OVER(PARTITION BY custid
ORDER BY orderdate, orderid
ROWS BETWEEN UNBOUNDED PRECEDING
AND CURRENT ROW) AS runningtotal
FROM Sales.OrderValues;

1	10643	2007-08-25 00:00:00.000	814.50	814.50
1	10692	2007-10-03 00:00:00.000	878.00	1692.50
1	10702	2007-10-13 00:00:00.000	330.00	2022.50
1	10835	2008-01-15 00:00:00.000	845.80	2868.30
1	10952	2008-03-16 00:00:00.000	471.20	3339.50
1	11011	2008-04-09 00:00:00.000	933.50	4273.00
2	10308	2006-09-18 00:00:00.000	88.80	88.80
2	10625	2007-08-08 00:00:00.000	479.75	568.55
2	10759	2007-11-28 00:00:00.000	320.00	888.55
2	10926	2008-03-04 00:00:00.000	514.40	1402.95
3	10365	2006-11-27 00:00:00.000	403.20	403.20
3	10507	2007-04-15 00:00:00.000	749.06	1152.26
3	10535	2007-05-13 00:00:00.000	1940.85	3093.11
3	10573	2007-06-19 00:00:00.000	2082.00	5175.11
3	10677	2007-09-22 00:00:00.000	813.37	5988.48
3	10682	2007-09-25 00:00:00.000	375.50	6363.98
3	10856	2008-01-28 00:00:00.000	660.00	7023.98
4	10355	2006-11-15 00:00:00.000	480.00	480.00
4	10383	2006-12-16 00:00:00.000	899.00	1379.00
4	10453	2007-02-21 00:00:00.000	407.70	1786.70
4	10558	2007-06-04 00:00:00.000	2142.90	3929.60
4	10707	2007-10-16 00:00:00.000	1641.00	5570.60
4	10741	2007-11-14 00:00:00.000	228.00	5798.60
4	10743	2007-11-17 00:00:00.000	319.20	6117.80
4	10768	2007-12-08 00:00:00.000	1477.00	7594.80
4	10793	2007-12-24 00:00:00.000	191.10	7785.90
4	10864	2008-02-02 00:00:00.000	282.00	8067.90
4	10920	2008-03-03 00:00:00.000	390.00	8457.90
4	10953	2008-03-16 00:00:00.000	4441.25	12899.15
4	11016	2008-04-10 00:00:00.000	491.50	13390.65
5	10278	2006-08-12 00:00:00.000	1488.80	1488.80
5	10280	2006-08-14 00:00:00.000	613.20	2102.00
5	10384	2006-12-16 00:00:00.000	2222.40	4324.40
5	10444	2007-02-12 00:00:00.000	1031.70	5356.10
5	10445	2007-02-13 00:00:00.000	174.90	5531.00
5	10524	2007-05-01 00:00:00.000	3192.65	8723.65
5	10572	2007-06-18 00:00:00.000	1501.09	10224.74
5	10626	2007-08-11 00:00:00.000	1503.60	11728.34
5	10654	2007-09-02 00:00:00.000	601.83	12330.17
5	10672	2007-09-17 00:00:00.000	3815.25	16145.42
5	10689	2007-10-01 00:00:00.000	472.50	16617.92
5	10733	2007-11-07 00:00:00.000	1459.00	18076.92
5	10778	2007-12-16 00:00:00.000	96.50	18173.42
5	10837	2008-01-16 00:00:00.000	1064.50	19237.92
5	10857	2008-01-28 00:00:00.000	2048.21	21286.13
5	10866	2008-02-03 00:00:00.000	1096.20	22382.33
5	10875	2008-02-06 00:00:00.000	709.55	23091.88
5	10924	2008-03-04 00:00:00.000	1835.70	24927.58
6	10501	2007-04-09 00:00:00.000	149.00	149.00
6	10509	2007-04-17 00:00:00.000	136.80	285.80
6	10582	2007-06-27 00:00:00.000	330.00	615.80
6	10614	2007-07-29 00:00:00.000	464.00	1079.80
6	10853	2008-01-27 00:00:00.000	625.00	1704.80
6	10956	2008-03-17 00:00:00.000	677.00	2381.80
6	11058	2008-04-29 00:00:00.000	858.00	3239.80
7	10265	2006-07-25 00:00:00.000	1176.00	1176.00
7	10297	2006-09-04 00:00:00.000	1420.00	2596.00
7	10360	2006-11-22 00:00:00.000	7390.20	9986.20
7	10436	2007-02-05 00:00:00.000	1994.52	11980.72
7	10449	2007-02-18 00:00:00.000	1838.20	13818.92
7	10559	2007-06-05 00:00:00.000	520.41	14339.33
7	10566	2007-06-12 00:00:00.000	1761.00	16100.33
7	10584	2007-06-30 00:00:00.000	593.75	16694.08
7	10628	2007-08-12 00:00:00.000	450.00	17144.08
7	10679	2007-09-23 00:00:00.000	660.00	17804.08
7	10826	2008-01-12 00:00:00.000	730.00	18534.08
8	10326	2006-10-10 00:00:00.000	982.00	982.00
8	10801	2007-12-29 00:00:00.000	3026.85	4008.85
8	10970	2008-03-24 00:00:00.000	224.00	4232.85
9	10331	2006-10-16 00:00:00.000	88.50	88.50
9	10340	2006-10-29 00:00:00.000	2436.18	2524.68
9	10362	2006-11-25 00:00:00.000	1549.60	4074.28
9	10470	2007-03-11 00:00:00.000	1820.80	5895.08
9	10511	2007-04-18 00:00:00.000	2550.00	8445.08
9	10525	2007-05-02 00:00:00.000	818.40	9263.48
9	10663	2007-09-10 00:00:00.000	1930.40	11193.88
9	10715	2007-10-23 00:00:00.000	1296.00	12489.88
9	10730	2007-11-05 00:00:00.000	484.26	12974.14
9	10732	2007-11-06 00:00:00.000	360.00	13334.14
9	10755	2007-11-26 00:00:00.000	1948.50	15282.64
9	10827	2008-01-12 00:00:00.000	843.00	16125.64
9	10871	2008-02-05 00:00:00.000	1979.23	18104.87
9	10876	2008-02-09 00:00:00.000	917.00	19021.87
9	10932	2008-03-06 00:00:00.000	1788.63	20810.50
9	10940	2008-03-11 00:00:00.000	360.00	21170.50
9	11076	2008-05-06 00:00:00.000	792.75	21963.25
10	10389	2006-12-20 00:00:00.000	1832.80	1832.80
10	10410	2007-01-10 00:00:00.000	802.00	2634.80
10	10411	2007-01-10 00:00:00.000	966.80	3601.60
10	10431	2007-01-30 00:00:00.000	1892.25	5493.85
10	10492	2007-04-01 00:00:00.000	851.20	6345.05
10	10742	2007-11-14 00:00:00.000	3118.00	9463.05
10	10918	2008-03-02 00:00:00.000	1447.50	10910.55
10	10944	2008-03-12 00:00:00.000	1025.33	11935.88
10	10949	2008-03-13 00:00:00.000	4422.00	16357.88
10	10975	2008-03-25 00:00:00.000	717.50	17075.38
10	10982	2008-03-27 00:00:00.000	1014.00	18089.38
10	11027	2008-04-16 00:00:00.000	877.73	18967.11
10	11045	2008-04-23 00:00:00.000	1309.50	20276.61
10	11048	2008-04-24 00:00:00.000	525.00	20801.61
11	10289	2006-08-26 00:00:00.000	479.40	479.40
11	10471	2007-03-11 00:00:00.000	1328.00	1807.40
11	10484	2007-03-24 00:00:00.000	386.20	2193.60
11	10538	2007-05-15 00:00:00.000	139.80	2333.40
11	10539	2007-05-16 00:00:00.000	355.50	2688.90
11	10578	2007-06-24 00:00:00.000	477.00	3165.90
11	10599	2007-07-15 00:00:00.000	493.00	3658.90
11	10943	2008-03-11 00:00:00.000	711.00	4369.90
11	10947	2008-03-13 00:00:00.000	220.00	4589.90
11	11023	2008-04-14 00:00:00.000	1500.00	6089.90
12	10521	2007-04-29 00:00:00.000	225.50	225.50
12	10782	2007-12-17 00:00:00.000	12.50	238.00
12	10819	2008-01-07 00:00:00.000	477.00	715.00
12	10881	2008-02-11 00:00:00.000	150.00	865.00
12	10937	2008-03-10 00:00:00.000	644.80	1509.80
12	11054	2008-04-28 00:00:00.000	305.00	1814.80
13	10259	2006-07-18 00:00:00.000	100.80	100.80
14	10254	2006-07-11 00:00:00.000	556.62	556.62
14	10370	2006-12-03 00:00:00.000	1117.60	1674.22
14	10519	2007-04-28 00:00:00.000	2314.20	3988.42
14	10731	2007-11-06 00:00:00.000	1890.50	5878.92
14	10746	2007-11-19 00:00:00.000	2311.70	8190.62
14	10966	2008-03-20 00:00:00.000	1098.46	9289.08
14	11029	2008-04-16 00:00:00.000	1286.80	10575.88
14	11041	2008-04-22 00:00:00.000	1773.00	12348.88
15	10290	2006-08-27 00:00:00.000	2169.00	2169.00
15	10466	2007-03-06 00:00:00.000	216.00	2385.00
15	10494	2007-04-02 00:00:00.000	912.00	3297.00
15	10969	2008-03-23 00:00:00.000	108.00	3405.00
15	11042	2008-04-22 00:00:00.000	405.75	3810.75
16	10435	2007-02-04 00:00:00.000	631.60	631.60
16	10462	2007-03-03 00:00:00.000	156.00	787.60
16	10848	2008-01-23 00:00:00.000	931.50	1719.10
17	10363	2006-11-26 00:00:00.000	447.20	447.20
17	10391	2006-12-23 00:00:00.000	86.40	533.60
17	10797	2007-12-25 00:00:00.000	420.00	953.60
17	10825	2008-01-09 00:00:00.000	1030.76	1984.36
17	11036	2008-04-20 00:00:00.000	1692.00	3676.36
17	11067	2008-05-04 00:00:00.000	86.85	3763.21
18	10311	2006-09-20 00:00:00.000	268.80	268.80
18	10609	2007-07-24 00:00:00.000	424.00	692.80
18	10683	2007-09-26 00:00:00.000	63.00	755.80
18	10890	2008-02-16 00:00:00.000	860.10	1615.90
19	10364	2006-11-26 00:00:00.000	950.00	950.00
19	10400	2007-01-01 00:00:00.000	3063.00	4013.00
19	10532	2007-05-09 00:00:00.000	796.35	4809.35
19	10726	2007-11-03 00:00:00.000	655.00	5464.35
19	10987	2008-03-31 00:00:00.000	2772.00	8236.35
19	11024	2008-04-15 00:00:00.000	1966.81	10203.16
19	11047	2008-04-24 00:00:00.000	817.88	11021.04
19	11056	2008-04-28 00:00:00.000	3740.00	14761.04
20	10258	2006-07-17 00:00:00.000	1614.88	1614.88
20	10263	2006-07-23 00:00:00.000	1873.80	3488.68
20	10351	2006-11-11 00:00:00.000	5398.73	8887.41
20	10368	2006-11-29 00:00:00.000	1689.78	10577.19
20	10382	2006-12-13 00:00:00.000	2900.00	13477.19
20	10390	2006-12-23 00:00:00.000	2090.88	15568.07
20	10402	2007-01-02 00:00:00.000	2713.50	18281.57
20	10403	2007-01-03 00:00:00.000	855.02	19136.59
20	10430	2007-01-30 00:00:00.000	4899.20	24035.79
20	10442	2007-02-11 00:00:00.000	1792.00	25827.79
20	10514	2007-04-22 00:00:00.000	8623.45	34451.24
20	10571	2007-06-17 00:00:00.000	550.59	35001.83
20	10595	2007-07-10 00:00:00.000	4725.00	39726.83
20	10633	2007-08-15 00:00:00.000	5510.59	45237.42
20	10667	2007-09-12 00:00:00.000	1536.80	46774.22
20	10698	2007-10-09 00:00:00.000	3436.44	50210.66
20	10764	2007-12-03 00:00:00.000	2286.00	52496.66
20	10771	2007-12-10 00:00:00.000	344.00	52840.66
20	10773	2007-12-11 00:00:00.000	2030.40	54871.06
20	10776	2007-12-15 00:00:00.000	6635.28	61506.34
20	10795	2007-12-24 00:00:00.000	2158.00	63664.34
20	10836	2008-01-16 00:00:00.000	4705.50	68369.84
20	10854	2008-01-27 00:00:00.000	2966.50	71336.34
20	10895	2008-02-18 00:00:00.000	6379.40	77715.74
20	10968	2008-03-23 00:00:00.000	1408.00	79123.74
20	10979	2008-03-26 00:00:00.000	4813.50	83937.24
20	10990	2008-04-01 00:00:00.000	4288.85	88226.09
20	11008	2008-04-08 00:00:00.000	4680.90	92906.99
20	11017	2008-04-13 00:00:00.000	6750.00	99656.99
20	11072	2008-05-05 00:00:00.000	5218.00	104874.99
21	10347	2006-11-06 00:00:00.000	814.42	814.42
21	10386	2006-12-18 00:00:00.000	166.00	980.42
21	10414	2007-01-14 00:00:00.000	224.83	1205.25
21	10512	2007-04-21 00:00:00.000	525.30	1730.55
21	10581	2007-06-26 00:00:00.000	310.00	2040.55
21	10650	2007-08-29 00:00:00.000	1779.20	3819.75
21	10725	2007-10-31 00:00:00.000	287.80	4107.55
23	10408	2007-01-08 00:00:00.000	1622.40	1622.40
23	10480	2007-03-20 00:00:00.000	756.00	2378.40
23	10634	2007-08-15 00:00:00.000	4985.50	7363.90
23	10763	2007-12-03 00:00:00.000	616.00	7979.90
23	10789	2007-12-22 00:00:00.000	3687.00	11666.90
24	10264	2006-07-24 00:00:00.000	695.63	695.63
24	10327	2006-10-11 00:00:00.000	1810.00	2505.63
24	10378	2006-12-10 00:00:00.000	103.20	2608.83
24	10434	2007-02-03 00:00:00.000	321.12	2929.95
24	10460	2007-02-28 00:00:00.000	176.10	3106.05
24	10533	2007-05-12 00:00:00.000	2222.20	5328.25
24	10561	2007-06-06 00:00:00.000	2844.50	8172.75
24	10703	2007-10-14 00:00:00.000	2545.00	10717.75
24	10762	2007-12-02 00:00:00.000	4337.00	15054.75
24	10774	2007-12-11 00:00:00.000	868.75	15923.50
24	10824	2008-01-09 00:00:00.000	250.80	16174.30
24	10880	2008-02-10 00:00:00.000	1500.00	17674.30
24	10902	2008-02-23 00:00:00.000	863.43	18537.73
24	10955	2008-03-17 00:00:00.000	74.40	18612.13
24	10977	2008-03-26 00:00:00.000	2233.00	20845.13
24	10980	2008-03-27 00:00:00.000	248.00	21093.13
24	10993	2008-04-01 00:00:00.000	4895.44	25988.57
24	11001	2008-04-06 00:00:00.000	2769.00	28757.57
24	11050	2008-04-27 00:00:00.000	810.00	29567.57
25	10267	2006-07-29 00:00:00.000	3536.60	3536.60
25	10337	2006-10-24 00:00:00.000	2467.00	6003.60
25	10342	2006-10-30 00:00:00.000	1840.64	7844.24
25	10396	2006-12-27 00:00:00.000	1903.80	9748.04
25	10488	2007-03-27 00:00:00.000	1512.00	11260.04
25	10560	2007-06-06 00:00:00.000	1072.43	12332.47
25	10623	2007-08-07 00:00:00.000	1336.95	13669.42
25	10653	2007-09-02 00:00:00.000	1083.15	14752.57
25	10670	2007-09-16 00:00:00.000	2301.75	17054.32
25	10675	2007-09-19 00:00:00.000	1423.00	18477.32
25	10717	2007-10-24 00:00:00.000	1270.75	19748.07
25	10791	2007-12-23 00:00:00.000	1829.76	21577.83
25	10859	2008-01-29 00:00:00.000	1078.69	22656.52
25	10929	2008-03-05 00:00:00.000	1174.75	23831.27
25	11012	2008-04-09 00:00:00.000	2825.30	26656.57
26	10671	2007-09-17 00:00:00.000	920.10	920.10
26	10860	2008-01-29 00:00:00.000	519.00	1439.10
26	10971	2008-03-24 00:00:00.000	1733.06	3172.16
27	10422	2007-01-22 00:00:00.000	49.80	49.80
27	10710	2007-10-20 00:00:00.000	93.50	143.30
27	10753	2007-11-25 00:00:00.000	88.00	231.30
27	10807	2007-12-31 00:00:00.000	18.40	249.70
27	11026	2008-04-15 00:00:00.000	1030.00	1279.70
27	11060	2008-04-30 00:00:00.000	266.00	1545.70
28	10328	2006-10-14 00:00:00.000	1168.00	1168.00
28	10352	2006-11-12 00:00:00.000	136.30	1304.30
28	10464	2007-03-04 00:00:00.000	1609.28	2913.58
28	10491	2007-03-31 00:00:00.000	259.51	3173.09
28	10551	2007-05-28 00:00:00.000	1677.30	4850.39
28	10604	2007-07-18 00:00:00.000	230.85	5081.24
28	10664	2007-09-10 00:00:00.000	1288.39	6369.63
28	10963	2008-03-19 00:00:00.000	57.80	6427.43
29	10366	2006-11-28 00:00:00.000	136.00	136.00
29	10426	2007-01-27 00:00:00.000	338.20	474.20
29	10568	2007-06-13 00:00:00.000	155.00	629.20
29	10887	2008-02-13 00:00:00.000	70.00	699.20
29	10928	2008-03-05 00:00:00.000	137.50	836.70
30	10303	2006-09-11 00:00:00.000	1117.80	1117.80
30	10550	2007-05-28 00:00:00.000	683.30	1801.10
30	10629	2007-08-12 00:00:00.000	2775.05	4576.15
30	10872	2008-02-05 00:00:00.000	2058.46	6634.61
30	10874	2008-02-06 00:00:00.000	310.00	6944.61
30	10888	2008-02-16 00:00:00.000	605.00	7549.61
30	10911	2008-02-26 00:00:00.000	858.00	8407.61
30	10948	2008-03-13 00:00:00.000	2362.25	10769.86
30	11009	2008-04-08 00:00:00.000	616.50	11386.36
30	11037	2008-04-21 00:00:00.000	60.00	11446.36
31	10423	2007-01-23 00:00:00.000	1020.00	1020.00
31	10652	2007-09-01 00:00:00.000	318.84	1338.84
31	10685	2007-09-29 00:00:00.000	801.10	2139.94
31	10709	2007-10-17 00:00:00.000	3424.00	5563.94
31	10734	2007-11-07 00:00:00.000	1498.35	7062.29
31	10777	2007-12-15 00:00:00.000	224.00	7286.29
31	10790	2007-12-22 00:00:00.000	722.50	8008.79
31	10959	2008-03-18 00:00:00.000	131.75	8140.54
31	11049	2008-04-24 00:00:00.000	273.60	8414.14
32	10528	2007-05-06 00:00:00.000	392.20	392.20
32	10589	2007-07-04 00:00:00.000	72.00	464.20
32	10616	2007-07-31 00:00:00.000	4807.00	5271.20
32	10617	2007-07-31 00:00:00.000	1402.50	6673.70
32	10656	2007-09-04 00:00:00.000	604.22	7277.92
32	10681	2007-09-25 00:00:00.000	1287.40	8565.32
32	10816	2008-01-06 00:00:00.000	8446.45	17011.77
32	10936	2008-03-09 00:00:00.000	456.00	17467.77
32	11006	2008-04-07 00:00:00.000	329.69	17797.46
32	11040	2008-04-22 00:00:00.000	200.00	17997.46
32	11061	2008-04-30 00:00:00.000	510.00	18507.46
33	10268	2006-07-30 00:00:00.000	1101.20	1101.20
33	10785	2007-12-18 00:00:00.000	387.50	1488.70
34	10250	2006-07-08 00:00:00.000	1552.60	1552.60
34	10253	2006-07-10 00:00:00.000	1444.80	2997.40
34	10541	2007-05-19 00:00:00.000	1946.52	4943.92
34	10645	2007-08-26 00:00:00.000	1535.00	6478.92
34	10690	2007-10-02 00:00:00.000	862.50	7341.42
34	10770	2007-12-09 00:00:00.000	236.25	7577.67
34	10783	2007-12-18 00:00:00.000	1442.50	9020.17
34	10886	2008-02-13 00:00:00.000	3127.50	12147.67
34	10903	2008-02-24 00:00:00.000	932.05	13079.72
34	10922	2008-03-03 00:00:00.000	742.50	13822.22
34	10925	2008-03-04 00:00:00.000	475.15	14297.37
34	10981	2008-03-27 00:00:00.000	15810.00	30107.37
34	11022	2008-04-14 00:00:00.000	1402.00	31509.37
34	11052	2008-04-27 00:00:00.000	1332.00	32841.37
35	10257	2006-07-16 00:00:00.000	1119.90	1119.90
35	10395	2006-12-26 00:00:00.000	2122.92	3242.82
35	10476	2007-03-17 00:00:00.000	180.48	3423.30
35	10486	2007-03-26 00:00:00.000	1272.00	4695.30
35	10490	2007-03-31 00:00:00.000	3163.20	7858.50
35	10498	2007-04-07 00:00:00.000	575.00	8433.50
35	10552	2007-05-29 00:00:00.000	880.50	9314.00
35	10601	2007-07-16 00:00:00.000	2285.00	11599.00
35	10613	2007-07-29 00:00:00.000	353.20	11952.20
35	10641	2007-08-22 00:00:00.000	2054.00	14006.20
35	10705	2007-10-15 00:00:00.000	378.00	14384.20
35	10796	2007-12-25 00:00:00.000	2341.36	16725.56
35	10863	2008-02-02 00:00:00.000	441.15	17166.71
35	10901	2008-02-23 00:00:00.000	934.50	18101.21
35	10957	2008-03-18 00:00:00.000	1762.70	19863.91
35	10960	2008-03-19 00:00:00.000	265.35	20129.26
35	10976	2008-03-25 00:00:00.000	912.00	21041.26
35	11055	2008-04-28 00:00:00.000	1727.50	22768.76
36	10375	2006-12-06 00:00:00.000	338.00	338.00
36	10394	2006-12-25 00:00:00.000	442.00	780.00
36	10415	2007-01-15 00:00:00.000	102.40	882.40
36	10600	2007-07-16 00:00:00.000	479.80	1362.20
36	10660	2007-09-08 00:00:00.000	1701.00	3063.20
37	10298	2006-09-05 00:00:00.000	2645.00	2645.00
37	10309	2006-09-19 00:00:00.000	1762.00	4407.00
37	10335	2006-10-22 00:00:00.000	2036.16	6443.16
37	10373	2006-12-05 00:00:00.000	1366.40	7809.56
37	10380	2006-12-12 00:00:00.000	1313.82	9123.38
37	10429	2007-01-29 00:00:00.000	1441.38	10564.76
37	10503	2007-04-11 00:00:00.000	2048.50	12613.26
37	10516	2007-04-24 00:00:00.000	2381.05	14994.31
37	10567	2007-06-12 00:00:00.000	2519.00	17513.31
37	10646	2007-08-27 00:00:00.000	1446.00	18959.31
37	10661	2007-09-09 00:00:00.000	562.60	19521.91
37	10687	2007-09-30 00:00:00.000	4960.90	24482.81
37	10701	2007-10-13 00:00:00.000	2864.50	27347.31
37	10712	2007-10-21 00:00:00.000	1233.48	28580.79
37	10736	2007-11-11 00:00:00.000	997.00	29577.79
37	10897	2008-02-19 00:00:00.000	10835.24	40413.03
37	10912	2008-02-26 00:00:00.000	6200.55	46613.58
37	10985	2008-03-30 00:00:00.000	2023.38	48636.96
37	11063	2008-04-30 00:00:00.000	1342.95	49979.91
38	10315	2006-09-26 00:00:00.000	516.80	516.80
38	10318	2006-10-01 00:00:00.000	240.40	757.20
38	10321	2006-10-03 00:00:00.000	144.00	901.20
38	10473	2007-03-13 00:00:00.000	230.40	1131.60
38	10621	2007-08-05 00:00:00.000	758.50	1890.10
38	10674	2007-09-18 00:00:00.000	45.00	1935.10
38	10749	2007-11-20 00:00:00.000	1080.00	3015.10
38	10798	2007-12-26 00:00:00.000	446.60	3461.70
38	10829	2008-01-13 00:00:00.000	1764.00	5225.70
38	10933	2008-03-06 00:00:00.000	920.60	6146.30
39	10323	2006-10-07 00:00:00.000	164.40	164.40
39	10325	2006-10-09 00:00:00.000	1497.00	1661.40
39	10456	2007-02-25 00:00:00.000	557.60	2219.00
39	10457	2007-02-25 00:00:00.000	1584.00	3803.00
39	10468	2007-03-07 00:00:00.000	717.60	4520.60
39	10506	2007-04-15 00:00:00.000	415.80	4936.40
39	10542	2007-05-20 00:00:00.000	469.11	5405.51
39	10630	2007-08-13 00:00:00.000	903.60	6309.11
39	10718	2007-10-27 00:00:00.000	3463.00	9772.11
39	10799	2007-12-26 00:00:00.000	1553.50	11325.61
39	10817	2008-01-06 00:00:00.000	10952.85	22278.46
39	10849	2008-01-23 00:00:00.000	967.82	23246.28
39	10893	2008-02-18 00:00:00.000	5502.11	28748.39
39	11028	2008-04-16 00:00:00.000	2160.00	30908.39
40	10858	2008-01-29 00:00:00.000	649.00	649.00
40	10927	2008-03-05 00:00:00.000	800.00	1449.00
40	10972	2008-03-24 00:00:00.000	251.50	1700.50
40	10973	2008-03-24 00:00:00.000	291.55	1992.05
41	10350	2006-11-11 00:00:00.000	642.06	642.06
41	10358	2006-11-20 00:00:00.000	429.40	1071.46
41	10371	2006-12-03 00:00:00.000	72.96	1144.42
41	10413	2007-01-14 00:00:00.000	2123.20	3267.62
41	10425	2007-01-24 00:00:00.000	360.00	3627.62
41	10454	2007-02-21 00:00:00.000	331.20	3958.82
41	10493	2007-04-02 00:00:00.000	608.40	4567.22
41	10500	2007-04-09 00:00:00.000	523.26	5090.48
41	10610	2007-07-25 00:00:00.000	299.25	5389.73
41	10631	2007-08-14 00:00:00.000	55.80	5445.53
41	10787	2007-12-19 00:00:00.000	2622.76	8068.29
41	10832	2008-01-14 00:00:00.000	475.11	8543.40
41	10923	2008-03-03 00:00:00.000	748.80	9292.20
41	11051	2008-04-27 00:00:00.000	36.00	9328.20
42	10495	2007-04-03 00:00:00.000	278.00	278.00
42	10620	2007-08-05 00:00:00.000	57.50	335.50
42	10810	2008-01-01 00:00:00.000	187.00	522.50
43	10482	2007-03-21 00:00:00.000	147.00	147.00
43	10545	2007-05-22 00:00:00.000	210.00	357.00
44	10279	2006-08-13 00:00:00.000	351.00	351.00
44	10284	2006-08-19 00:00:00.000	1170.38	1521.38
44	10343	2006-10-31 00:00:00.000	1584.00	3105.38
44	10497	2007-04-04 00:00:00.000	1380.60	4485.98
44	10522	2007-04-30 00:00:00.000	2318.24	6804.22
44	10534	2007-05-12 00:00:00.000	465.70	7269.92
44	10536	2007-05-14 00:00:00.000	1645.00	8914.92
44	10557	2007-06-03 00:00:00.000	1152.50	10067.42
44	10592	2007-07-08 00:00:00.000	516.47	10583.89
44	10593	2007-07-09 00:00:00.000	1994.40	12578.29
44	10772	2007-12-10 00:00:00.000	3603.22	16181.51
44	10862	2008-01-30 00:00:00.000	581.00	16762.51
44	10891	2008-02-17 00:00:00.000	368.93	17131.44
44	10934	2008-03-09 00:00:00.000	500.00	17631.44
44	11070	2008-05-05 00:00:00.000	1629.98	19261.42
45	10579	2007-06-25 00:00:00.000	317.75	317.75
45	10719	2007-10-27 00:00:00.000	844.25	1162.00
45	10735	2007-11-10 00:00:00.000	536.40	1698.40
45	10884	2008-02-12 00:00:00.000	1378.07	3076.47
46	10283	2006-08-16 00:00:00.000	1414.80	1414.80
46	10296	2006-09-03 00:00:00.000	1050.60	2465.40
46	10330	2006-10-16 00:00:00.000	1649.00	4114.40
46	10357	2006-11-19 00:00:00.000	1167.68	5282.08
46	10381	2006-12-12 00:00:00.000	112.00	5394.08
46	10461	2007-02-28 00:00:00.000	1538.70	6932.78
46	10499	2007-04-08 00:00:00.000	1412.00	8344.78
46	10543	2007-05-21 00:00:00.000	1504.50	9849.28
46	10780	2007-12-16 00:00:00.000	720.00	10569.28
46	10823	2008-01-09 00:00:00.000	2826.00	13395.28
46	10899	2008-02-20 00:00:00.000	122.40	13517.68
46	10997	2008-04-03 00:00:00.000	1885.00	15402.68
46	11065	2008-05-01 00:00:00.000	189.42	15592.10
46	11071	2008-05-05 00:00:00.000	484.50	16076.60
47	10405	2007-01-06 00:00:00.000	400.00	400.00
47	10485	2007-03-25 00:00:00.000	1584.00	1984.00
47	10638	2007-08-20 00:00:00.000	2720.05	4704.05
47	10697	2007-10-08 00:00:00.000	805.43	5509.48
47	10729	2007-11-04 00:00:00.000	1850.00	7359.48
47	10811	2008-01-02 00:00:00.000	852.00	8211.48
47	10838	2008-01-19 00:00:00.000	1938.38	10149.86
47	10840	2008-01-19 00:00:00.000	211.20	10361.06
47	10919	2008-03-02 00:00:00.000	1122.80	11483.86
47	10954	2008-03-17 00:00:00.000	1659.54	13143.40
47	11014	2008-04-10 00:00:00.000	243.18	13386.58
47	11039	2008-04-21 00:00:00.000	3090.00	16476.58
48	10307	2006-09-17 00:00:00.000	424.00	424.00
48	10317	2006-09-30 00:00:00.000	288.00	712.00
48	10544	2007-05-21 00:00:00.000	417.20	1129.20
48	10662	2007-09-09 00:00:00.000	125.00	1254.20
48	10665	2007-09-11 00:00:00.000	1295.00	2549.20
48	10867	2008-02-03 00:00:00.000	98.40	2647.60
48	10883	2008-02-12 00:00:00.000	36.00	2683.60
48	11018	2008-04-13 00:00:00.000	1575.00	4258.60
49	10275	2006-08-07 00:00:00.000	291.84	291.84
49	10300	2006-09-09 00:00:00.000	608.00	899.84
49	10404	2007-01-03 00:00:00.000	1591.25	2491.09
49	10467	2007-03-06 00:00:00.000	235.20	2726.29
49	10635	2007-08-18 00:00:00.000	1326.23	4052.52
49	10754	2007-11-25 00:00:00.000	55.20	4107.72
49	10784	2007-12-18 00:00:00.000	1488.00	5595.72
49	10818	2008-01-07 00:00:00.000	833.00	6428.72
49	10939	2008-03-10 00:00:00.000	637.50	7066.22
49	10950	2008-03-16 00:00:00.000	110.00	7176.22
50	10529	2007-05-07 00:00:00.000	946.00	946.00
50	10649	2007-08-28 00:00:00.000	1434.00	2380.00
50	10760	2007-12-01 00:00:00.000	2917.00	5297.00
50	10892	2008-02-17 00:00:00.000	2090.00	7387.00
50	10896	2008-02-19 00:00:00.000	750.50	8137.50
50	10978	2008-03-26 00:00:00.000	1303.20	9440.70
50	11004	2008-04-07 00:00:00.000	295.38	9736.08
51	10332	2006-10-17 00:00:00.000	1786.88	1786.88
51	10339	2006-10-28 00:00:00.000	3354.00	5140.88
51	10376	2006-12-09 00:00:00.000	399.00	5539.88
51	10424	2007-01-23 00:00:00.000	9194.56	14734.44
51	10439	2007-02-07 00:00:00.000	1078.00	15812.44
51	10505	2007-04-14 00:00:00.000	147.90	15960.34
51	10565	2007-06-11 00:00:00.000	639.90	16600.24
51	10570	2007-06-17 00:00:00.000	2465.25	19065.49
51	10590	2007-07-07 00:00:00.000	1101.00	20166.49
51	10605	2007-07-21 00:00:00.000	4109.70	24276.19
51	10618	2007-08-01 00:00:00.000	2697.50	26973.69
51	10619	2007-08-04 00:00:00.000	1260.00	28233.69
51	10724	2007-10-30 00:00:00.000	638.50	28872.19
52	10277	2006-08-09 00:00:00.000	1200.80	1200.80
52	10575	2007-06-20 00:00:00.000	2147.40	3348.20
52	10699	2007-10-09 00:00:00.000	114.00	3462.20
52	10779	2007-12-16 00:00:00.000	1335.00	4797.20
52	10945	2008-03-12 00:00:00.000	245.00	5042.20
53	10517	2007-04-24 00:00:00.000	352.00	352.00
53	10752	2007-11-24 00:00:00.000	252.00	604.00
53	11057	2008-04-29 00:00:00.000	45.00	649.00
54	10409	2007-01-09 00:00:00.000	319.20	319.20
54	10531	2007-05-08 00:00:00.000	110.00	429.20
54	10898	2008-02-20 00:00:00.000	30.00	459.20
54	10958	2008-03-18 00:00:00.000	781.00	1240.20
54	10986	2008-03-30 00:00:00.000	2220.00	3460.20
55	10305	2006-09-13 00:00:00.000	3741.30	3741.30
55	10338	2006-10-25 00:00:00.000	934.50	4675.80
55	10441	2007-02-10 00:00:00.000	1755.00	6430.80
55	10594	2007-07-09 00:00:00.000	565.50	6996.30
55	10680	2007-09-24 00:00:00.000	1261.88	8258.18
55	10706	2007-10-16 00:00:00.000	1893.00	10151.18
55	10808	2008-01-01 00:00:00.000	1411.00	11562.18
55	10855	2008-01-27 00:00:00.000	2227.89	13790.07
55	10965	2008-03-20 00:00:00.000	848.00	14638.07
55	11034	2008-04-20 00:00:00.000	539.40	15177.47
56	10260	2006-07-19 00:00:00.000	1504.65	1504.65
56	10407	2007-01-07 00:00:00.000	1194.00	2698.65
56	10508	2007-04-16 00:00:00.000	240.00	2938.65
56	10554	2007-05-30 00:00:00.000	1728.53	4667.18
56	10580	2007-06-26 00:00:00.000	1013.75	5680.93
56	10684	2007-09-26 00:00:00.000	1768.00	7448.93
56	10766	2007-12-05 00:00:00.000	2310.00	9758.93
56	10833	2008-01-15 00:00:00.000	906.93	10665.86
56	10999	2008-04-03 00:00:00.000	1197.95	11863.81
56	11020	2008-04-14 00:00:00.000	632.40	12496.21
58	10322	2006-10-04 00:00:00.000	112.00	112.00
58	10354	2006-11-14 00:00:00.000	568.80	680.80
58	10474	2007-03-13 00:00:00.000	1249.10	1929.90
58	10502	2007-04-10 00:00:00.000	816.30	2746.20
58	10995	2008-04-02 00:00:00.000	1196.00	3942.20
58	11073	2008-05-05 00:00:00.000	300.00	4242.20
59	10353	2006-11-13 00:00:00.000	8593.28	8593.28
59	10392	2006-12-24 00:00:00.000	1440.00	10033.28
59	10427	2007-01-27 00:00:00.000	651.00	10684.28
59	10489	2007-03-28 00:00:00.000	439.20	11123.48
59	10530	2007-05-08 00:00:00.000	4180.00	15303.48
59	10597	2007-07-11 00:00:00.000	718.08	16021.56
59	10686	2007-09-30 00:00:00.000	1404.45	17426.01
59	10747	2007-11-19 00:00:00.000	1912.85	19338.86
59	10844	2008-01-21 00:00:00.000	735.00	20073.86
59	11053	2008-04-27 00:00:00.000	3055.00	23128.86
60	10336	2006-10-23 00:00:00.000	285.12	285.12
60	10397	2006-12-27 00:00:00.000	716.72	1001.84
60	10433	2007-02-03 00:00:00.000	851.20	1853.04
60	10477	2007-03-17 00:00:00.000	558.00	2411.04
60	11007	2008-04-08 00:00:00.000	2633.90	5044.94
61	10261	2006-07-19 00:00:00.000	448.00	448.00
61	10291	2006-08-27 00:00:00.000	497.52	945.52
61	10379	2006-12-11 00:00:00.000	863.28	1808.80
61	10421	2007-01-21 00:00:00.000	1194.27	3003.07
61	10587	2007-07-02 00:00:00.000	807.38	3810.45
61	10647	2007-08-27 00:00:00.000	636.00	4446.45
61	10720	2007-10-28 00:00:00.000	550.00	4996.45
61	10794	2007-12-24 00:00:00.000	314.76	5311.21
61	10989	2008-03-31 00:00:00.000	1353.60	6664.81
62	10372	2006-12-04 00:00:00.000	9210.90	9210.90
62	10406	2007-01-07 00:00:00.000	1830.78	11041.68
62	10487	2007-03-26 00:00:00.000	889.70	11931.38
62	10637	2007-08-19 00:00:00.000	2761.94	14693.32
62	10659	2007-09-05 00:00:00.000	1227.02	15920.34
62	10704	2007-10-14 00:00:00.000	595.50	16515.84
62	10728	2007-11-04 00:00:00.000	1296.75	17812.59
62	10786	2007-12-19 00:00:00.000	1531.08	19343.67
62	10868	2008-02-04 00:00:00.000	1920.60	21264.27
62	10913	2008-02-26 00:00:00.000	768.75	22033.02
62	10914	2008-02-27 00:00:00.000	537.50	22570.52
62	10961	2008-03-19 00:00:00.000	1119.90	23690.42
62	11068	2008-05-04 00:00:00.000	2027.08	25717.50
63	10273	2006-08-05 00:00:00.000	2037.28	2037.28
63	10285	2006-08-20 00:00:00.000	1743.36	3780.64
63	10286	2006-08-21 00:00:00.000	3016.00	6796.64
63	10313	2006-09-24 00:00:00.000	182.40	6979.04
63	10345	2006-11-04 00:00:00.000	2924.80	9903.84
63	10361	2006-11-22 00:00:00.000	2046.24	11950.08
63	10418	2007-01-17 00:00:00.000	1814.80	13764.88
63	10451	2007-02-19 00:00:00.000	3849.66	17614.54
63	10515	2007-04-23 00:00:00.000	9921.30	27535.84
63	10527	2007-05-05 00:00:00.000	1503.00	29038.84
63	10540	2007-05-19 00:00:00.000	10191.70	39230.54
63	10549	2007-05-27 00:00:00.000	3554.28	42784.82
63	10588	2007-07-03 00:00:00.000	3120.00	45904.82
63	10658	2007-09-05 00:00:00.000	4464.60	50369.42
63	10691	2007-10-03 00:00:00.000	10164.80	60534.22
63	10694	2007-10-06 00:00:00.000	4825.00	65359.22
63	10721	2007-10-29 00:00:00.000	923.88	66283.10
63	10745	2007-11-18 00:00:00.000	4529.80	70812.90
63	10765	2007-12-04 00:00:00.000	1515.60	72328.50
63	10788	2007-12-22 00:00:00.000	731.50	73060.00
63	10845	2008-01-21 00:00:00.000	3812.70	76872.70
63	10865	2008-02-02 00:00:00.000	16387.50	93260.20
63	10878	2008-02-10 00:00:00.000	1539.00	94799.20
63	10938	2008-03-10 00:00:00.000	2731.88	97531.08
63	10962	2008-03-19 00:00:00.000	3584.00	101115.08
63	10991	2008-04-01 00:00:00.000	2296.00	103411.08
63	10996	2008-04-02 00:00:00.000	560.00	103971.08
63	11021	2008-04-14 00:00:00.000	6306.24	110277.32
64	10448	2007-02-17 00:00:00.000	443.40	443.40
64	10716	2007-10-24 00:00:00.000	706.00	1149.40
64	10828	2008-01-13 00:00:00.000	932.00	2081.40
64	10916	2008-02-27 00:00:00.000	686.70	2768.10
64	11019	2008-04-13 00:00:00.000	76.00	2844.10
65	10262	2006-07-22 00:00:00.000	584.00	584.00
65	10272	2006-08-02 00:00:00.000	1456.00	2040.00
65	10294	2006-08-30 00:00:00.000	1887.60	3927.60
65	10314	2006-09-25 00:00:00.000	2094.30	6021.90
65	10316	2006-09-27 00:00:00.000	2835.00	8856.90
65	10346	2006-11-05 00:00:00.000	1618.88	10475.78
65	10401	2007-01-01 00:00:00.000	3868.60	14344.38
65	10479	2007-03-19 00:00:00.000	10495.60	24839.98
65	10564	2007-06-10 00:00:00.000	1234.05	26074.03
65	10569	2007-06-16 00:00:00.000	890.00	26964.03
65	10598	2007-07-14 00:00:00.000	2388.50	29352.53
65	10761	2007-12-02 00:00:00.000	507.00	29859.53
65	10820	2008-01-07 00:00:00.000	1140.00	30999.53
65	10852	2008-01-26 00:00:00.000	2984.00	33983.53
65	10889	2008-02-16 00:00:00.000	11380.00	45363.53
65	10988	2008-03-31 00:00:00.000	3574.80	48938.33
65	11000	2008-04-06 00:00:00.000	903.75	49842.08
65	11077	2008-05-06 00:00:00.000	1255.72	51097.80
66	10288	2006-08-23 00:00:00.000	80.10	80.10
66	10428	2007-01-28 00:00:00.000	192.00	272.10
66	10443	2007-02-12 00:00:00.000	517.44	789.54
66	10562	2007-06-09 00:00:00.000	488.70	1278.24
66	10586	2007-07-02 00:00:00.000	23.80	1302.04
66	10655	2007-09-03 00:00:00.000	154.40	1456.44
66	10727	2007-11-03 00:00:00.000	1624.50	3080.94
66	10812	2008-01-02 00:00:00.000	1692.80	4773.74
66	10908	2008-02-26 00:00:00.000	663.10	5436.84
66	10942	2008-03-11 00:00:00.000	560.00	5996.84
66	11010	2008-04-09 00:00:00.000	645.00	6641.84
66	11062	2008-04-30 00:00:00.000	406.40	7048.24
67	10287	2006-08-22 00:00:00.000	819.00	819.00
67	10299	2006-09-06 00:00:00.000	349.50	1168.50
67	10447	2007-02-14 00:00:00.000	914.40	2082.90
67	10481	2007-03-20 00:00:00.000	1472.00	3554.90
67	10563	2007-06-10 00:00:00.000	965.00	4519.90
67	10622	2007-08-06 00:00:00.000	560.00	5079.90
67	10648	2007-08-28 00:00:00.000	372.38	5452.28
67	10813	2008-01-05 00:00:00.000	602.40	6054.68
67	10851	2008-01-26 00:00:00.000	2603.00	8657.68
67	10877	2008-02-09 00:00:00.000	1955.13	10612.81
67	11059	2008-04-29 00:00:00.000	1838.00	12450.81
68	10255	2006-07-12 00:00:00.000	2490.50	2490.50
68	10419	2007-01-20 00:00:00.000	2097.60	4588.10
68	10537	2007-05-14 00:00:00.000	1823.80	6411.90
68	10666	2007-09-12 00:00:00.000	4666.94	11078.84
68	10751	2007-11-24 00:00:00.000	1631.48	12710.32
68	10758	2007-11-28 00:00:00.000	1644.60	14354.92
68	10931	2008-03-06 00:00:00.000	799.20	15154.12
68	10951	2008-03-16 00:00:00.000	458.76	15612.88
68	11033	2008-04-17 00:00:00.000	3232.80	18845.68
68	11075	2008-05-06 00:00:00.000	498.10	19343.78
69	10281	2006-08-14 00:00:00.000	86.50	86.50
69	10282	2006-08-15 00:00:00.000	155.40	241.90
69	10306	2006-09-16 00:00:00.000	498.50	740.40
69	10917	2008-03-02 00:00:00.000	365.89	1106.29
69	11013	2008-04-09 00:00:00.000	361.00	1467.29
70	10387	2006-12-18 00:00:00.000	1058.40	1058.40
70	10520	2007-04-29 00:00:00.000	200.00	1258.40
70	10639	2007-08-20 00:00:00.000	500.00	1758.40
70	10831	2008-01-14 00:00:00.000	2684.40	4442.80
70	10909	2008-02-26 00:00:00.000	670.00	5112.80
70	11015	2008-04-10 00:00:00.000	622.35	5735.15
71	10324	2006-10-08 00:00:00.000	5275.72	5275.72
71	10393	2006-12-25 00:00:00.000	2556.95	7832.67
71	10398	2006-12-30 00:00:00.000	2505.60	10338.27
71	10440	2007-02-10 00:00:00.000	4924.14	15262.41
71	10452	2007-02-20 00:00:00.000	2018.50	17280.91
71	10510	2007-04-18 00:00:00.000	4707.54	21988.45
71	10555	2007-06-02 00:00:00.000	2944.40	24932.85
71	10603	2007-07-18 00:00:00.000	1483.00	26415.85
71	10607	2007-07-22 00:00:00.000	6475.40	32891.25
71	10612	2007-07-28 00:00:00.000	6375.00	39266.25
71	10627	2007-08-11 00:00:00.000	1185.75	40452.00
71	10657	2007-09-04 00:00:00.000	4371.60	44823.60
71	10678	2007-09-23 00:00:00.000	5256.50	50080.10
71	10700	2007-10-10 00:00:00.000	1638.40	51718.50
71	10711	2007-10-21 00:00:00.000	4451.70	56170.20
71	10713	2007-10-22 00:00:00.000	2827.90	58998.10
71	10714	2007-10-22 00:00:00.000	2205.75	61203.85
71	10722	2007-10-29 00:00:00.000	1570.00	62773.85
71	10748	2007-11-20 00:00:00.000	2196.00	64969.85
71	10757	2007-11-27 00:00:00.000	3082.00	68051.85
71	10815	2008-01-05 00:00:00.000	40.00	68091.85
71	10847	2008-01-22 00:00:00.000	4931.92	73023.77
71	10882	2008-02-11 00:00:00.000	892.64	73916.41
71	10894	2008-02-18 00:00:00.000	2753.10	76669.51
71	10941	2008-03-11 00:00:00.000	4011.75	80681.26
71	10983	2008-03-27 00:00:00.000	720.90	81402.16
71	10984	2008-03-30 00:00:00.000	1809.75	83211.91
71	11002	2008-04-06 00:00:00.000	1811.10	85023.01
71	11030	2008-04-17 00:00:00.000	12615.05	97638.06
71	11031	2008-04-17 00:00:00.000	2393.50	100031.56
71	11064	2008-05-01 00:00:00.000	4330.40	104361.96
72	10359	2006-11-21 00:00:00.000	3471.68	3471.68
72	10377	2006-12-09 00:00:00.000	863.60	4335.28
72	10388	2006-12-19 00:00:00.000	1228.80	5564.08
72	10472	2007-03-12 00:00:00.000	1036.80	6600.88
72	10523	2007-05-01 00:00:00.000	2444.31	9045.19
72	10547	2007-05-23 00:00:00.000	1792.80	10837.99
72	10800	2007-12-26 00:00:00.000	1468.94	12306.93
72	10804	2007-12-30 00:00:00.000	2278.40	14585.33
72	10869	2008-02-04 00:00:00.000	1630.00	16215.33
73	10341	2006-10-29 00:00:00.000	352.60	352.60
73	10417	2007-01-16 00:00:00.000	11188.40	11541.00
73	10556	2007-06-03 00:00:00.000	835.20	12376.20
73	10642	2007-08-22 00:00:00.000	696.00	13072.20
73	10669	2007-09-15 00:00:00.000	570.00	13642.20
73	10802	2007-12-29 00:00:00.000	2942.81	16585.01
73	11074	2008-05-06 00:00:00.000	232.09	16817.10
74	10738	2007-11-12 00:00:00.000	52.35	52.35
74	10907	2008-02-25 00:00:00.000	108.50	160.85
74	10964	2008-03-20 00:00:00.000	2052.50	2213.35
74	11043	2008-04-22 00:00:00.000	210.00	2423.35
75	10271	2006-08-01 00:00:00.000	48.00	48.00
75	10329	2006-10-15 00:00:00.000	4578.43	4626.43
75	10349	2006-11-08 00:00:00.000	141.60	4768.03
75	10369	2006-12-02 00:00:00.000	2390.40	7158.43
75	10385	2006-12-17 00:00:00.000	691.20	7849.63
75	10432	2007-01-31 00:00:00.000	485.00	8334.63
75	10756	2007-11-27 00:00:00.000	1990.00	10324.63
75	10821	2008-01-08 00:00:00.000	678.00	11002.63
75	10974	2008-03-25 00:00:00.000	439.00	11441.63
76	10252	2006-07-09 00:00:00.000	3597.90	3597.90
76	10302	2006-09-10 00:00:00.000	2708.80	6306.70
76	10458	2007-02-26 00:00:00.000	3891.00	10197.70
76	10463	2007-03-04 00:00:00.000	713.30	10911.00
76	10475	2007-03-14 00:00:00.000	1505.18	12416.18
76	10767	2007-12-05 00:00:00.000	28.00	12444.18
76	10841	2008-01-20 00:00:00.000	4581.00	17025.18
76	10846	2008-01-22 00:00:00.000	1112.00	18137.18
76	10885	2008-02-12 00:00:00.000	1209.00	19346.18
76	10930	2008-03-06 00:00:00.000	2255.50	21601.68
76	11035	2008-04-20 00:00:00.000	1754.50	23356.18
76	11038	2008-04-21 00:00:00.000	732.60	24088.78
77	10310	2006-09-20 00:00:00.000	336.00	336.00
77	10708	2007-10-17 00:00:00.000	180.40	516.40
77	10805	2007-12-30 00:00:00.000	2775.00	3291.40
77	10992	2008-04-01 00:00:00.000	69.60	3361.00
78	10624	2007-08-07 00:00:00.000	1393.24	1393.24
78	10775	2007-12-12 00:00:00.000	228.00	1621.24
78	11003	2008-04-06 00:00:00.000	326.00	1947.24
79	10249	2006-07-05 00:00:00.000	1863.40	1863.40
79	10438	2007-02-06 00:00:00.000	454.00	2317.40
79	10446	2007-02-14 00:00:00.000	246.24	2563.64
79	10548	2007-05-26 00:00:00.000	240.10	2803.74
79	10608	2007-07-23 00:00:00.000	1064.00	3867.74
79	10967	2008-03-23 00:00:00.000	910.40	4778.14
80	10276	2006-08-08 00:00:00.000	420.00	420.00
80	10293	2006-08-29 00:00:00.000	848.70	1268.70
80	10304	2006-09-12 00:00:00.000	954.40	2223.10
80	10319	2006-10-02 00:00:00.000	1191.20	3414.30
80	10518	2007-04-25 00:00:00.000	4150.05	7564.35
80	10576	2007-06-23 00:00:00.000	838.45	8402.80
80	10676	2007-09-22 00:00:00.000	534.85	8937.65
80	10842	2008-01-20 00:00:00.000	975.00	9912.65
80	10915	2008-02-27 00:00:00.000	539.50	10452.15
80	11069	2008-05-04 00:00:00.000	360.00	10812.15
81	10292	2006-08-28 00:00:00.000	1296.00	1296.00
81	10496	2007-04-04 00:00:00.000	190.00	1486.00
81	10606	2007-07-22 00:00:00.000	1130.40	2616.40
81	10830	2008-01-13 00:00:00.000	1974.00	4590.40
81	10834	2008-01-15 00:00:00.000	1432.71	6023.11
81	10839	2008-01-19 00:00:00.000	827.55	6850.66
82	10574	2007-06-19 00:00:00.000	764.30	764.30
82	10577	2007-06-23 00:00:00.000	569.00	1333.30
82	10822	2008-01-08 00:00:00.000	237.90	1571.20
83	10367	2006-11-28 00:00:00.000	834.20	834.20
83	10399	2006-12-31 00:00:00.000	1765.60	2599.80
83	10465	2007-03-05 00:00:00.000	2518.00	5117.80
83	10591	2007-07-07 00:00:00.000	812.50	5930.30
83	10602	2007-07-17 00:00:00.000	48.75	5979.05
83	10688	2007-10-01 00:00:00.000	3160.60	9139.65
83	10744	2007-11-17 00:00:00.000	736.00	9875.65
83	10769	2007-12-08 00:00:00.000	1684.28	11559.93
83	10921	2008-03-03 00:00:00.000	1936.00	13495.93
83	10946	2008-03-12 00:00:00.000	1407.50	14903.43
83	10994	2008-04-02 00:00:00.000	940.50	15843.93
84	10251	2006-07-08 00:00:00.000	654.06	654.06
84	10334	2006-10-21 00:00:00.000	144.80	798.86
84	10450	2007-02-19 00:00:00.000	425.12	1223.98
84	10459	2007-02-27 00:00:00.000	1659.20	2883.18
84	10478	2007-03-18 00:00:00.000	471.20	3354.38
84	10546	2007-05-23 00:00:00.000	2812.00	6166.38
84	10806	2007-12-31 00:00:00.000	439.60	6605.98
84	10814	2008-01-05 00:00:00.000	1788.45	8394.43
84	10843	2008-01-21 00:00:00.000	159.00	8553.43
84	10850	2008-01-23 00:00:00.000	629.00	9182.43
85	10248	2006-07-04 00:00:00.000	440.00	440.00
85	10274	2006-08-06 00:00:00.000	538.60	978.60
85	10295	2006-09-02 00:00:00.000	121.60	1100.20
85	10737	2007-11-11 00:00:00.000	139.80	1240.00
85	10739	2007-11-12 00:00:00.000	240.00	1480.00
86	10301	2006-09-09 00:00:00.000	755.00	755.00
86	10312	2006-09-23 00:00:00.000	1614.80	2369.80
86	10348	2006-11-07 00:00:00.000	363.60	2733.40
86	10356	2006-11-18 00:00:00.000	1106.40	3839.80
86	10513	2007-04-22 00:00:00.000	1942.00	5781.80
86	10632	2007-08-14 00:00:00.000	589.00	6370.80
86	10640	2007-08-21 00:00:00.000	708.75	7079.55
86	10651	2007-09-01 00:00:00.000	397.80	7477.35
86	10668	2007-09-15 00:00:00.000	625.28	8102.63
86	11046	2008-04-23 00:00:00.000	1485.80	9588.43
87	10266	2006-07-26 00:00:00.000	346.56	346.56
87	10270	2006-08-01 00:00:00.000	1376.00	1722.56
87	10320	2006-10-03 00:00:00.000	516.00	2238.56
87	10333	2006-10-18 00:00:00.000	877.20	3115.76
87	10412	2007-01-13 00:00:00.000	334.80	3450.56
87	10416	2007-01-16 00:00:00.000	720.00	4170.56
87	10437	2007-02-05 00:00:00.000	393.00	4563.56
87	10455	2007-02-24 00:00:00.000	2684.00	7247.56
87	10526	2007-05-05 00:00:00.000	1151.40	8398.96
87	10553	2007-05-30 00:00:00.000	1546.30	9945.26
87	10583	2007-06-30 00:00:00.000	2237.50	12182.76
87	10636	2007-08-19 00:00:00.000	629.50	12812.26
87	10750	2007-11-21 00:00:00.000	1590.56	14402.82
87	10781	2007-12-17 00:00:00.000	975.88	15378.70
87	11025	2008-04-15 00:00:00.000	270.00	15648.70
88	10256	2006-07-15 00:00:00.000	517.80	517.80
88	10420	2007-01-21 00:00:00.000	1707.84	2225.64
88	10585	2007-07-01 00:00:00.000	142.50	2368.14
88	10644	2007-08-25 00:00:00.000	1371.80	3739.94
88	10803	2007-12-30 00:00:00.000	1193.01	4932.95
88	10809	2008-01-01 00:00:00.000	140.00	5072.95
88	10900	2008-02-20 00:00:00.000	33.75	5106.70
88	10905	2008-02-24 00:00:00.000	342.00	5448.70
88	10935	2008-03-09 00:00:00.000	619.50	6068.20
89	10269	2006-07-31 00:00:00.000	642.20	642.20
89	10344	2006-11-01 00:00:00.000	2296.00	2938.20
89	10469	2007-03-10 00:00:00.000	956.68	3894.88
89	10483	2007-03-24 00:00:00.000	668.80	4563.68
89	10504	2007-04-11 00:00:00.000	1388.50	5952.18
89	10596	2007-07-11 00:00:00.000	1180.88	7133.06
89	10693	2007-10-06 00:00:00.000	2071.20	9204.26
89	10696	2007-10-08 00:00:00.000	996.00	10200.26
89	10723	2007-10-30 00:00:00.000	468.45	10668.71
89	10740	2007-11-13 00:00:00.000	1416.00	12084.71
89	10861	2008-01-30 00:00:00.000	3523.40	15608.11
89	10904	2008-02-24 00:00:00.000	1924.25	17532.36
89	11032	2008-04-17 00:00:00.000	8902.50	26434.86
89	11066	2008-05-01 00:00:00.000	928.75	27363.61
90	10615	2007-07-30 00:00:00.000	120.00	120.00
90	10673	2007-09-18 00:00:00.000	412.35	532.35
90	10695	2007-10-07 00:00:00.000	642.00	1174.35
90	10873	2008-02-06 00:00:00.000	336.80	1511.15
90	10879	2008-02-10 00:00:00.000	611.30	2122.45
90	10910	2008-02-26 00:00:00.000	452.90	2575.35
90	11005	2008-04-07 00:00:00.000	586.00	3161.35
91	10374	2006-12-05 00:00:00.000	459.00	459.00
91	10611	2007-07-25 00:00:00.000	808.00	1267.00
91	10792	2007-12-23 00:00:00.000	399.85	1666.85
91	10870	2008-02-04 00:00:00.000	160.00	1826.85
91	10906	2008-02-25 00:00:00.000	427.50	2254.35
91	10998	2008-04-03 00:00:00.000	686.00	2940.35
91	11044	2008-04-23 00:00:00.000	591.60	3531.95

Open in new window

0
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
With ROWS BETWEEN 2 PRECEDING... finds sum of 3 rows (between includes both ends), 2 preceding and one current makes 3 rows.

1      10643      2007-08-25 00:00:00.000      814.50      814.50                  <--  814.50
1      10692      2007-10-03 00:00:00.000      878.00      1692.50                <--  814.50 + 878.00
1      10702      2007-10-13 00:00:00.000      330.00      2022.50                <--  814.50 + 878.00 + 330.00
1      10835      2008-01-15 00:00:00.000      845.80      2053.80                <--  878.00 + 330.00 + 845.80
1      10952      2008-03-16 00:00:00.000      471.20      1647.00
1      11011      2008-04-09 00:00:00.000      933.50      2250.50
2      10308      2006-09-18 00:00:00.000      88.80      88.80
2      10625      2007-08-08 00:00:00.000      479.75      568.55
2      10759      2007-11-28 00:00:00.000      320.00      888.55
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
I figured out the answer for my question. BTW, I had correct code to begin with but didn't know how it works.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.