General information
Forum:
Microsoft SQL Server
I have the following select:
Select Date, Code, Sum(Amount) as Total From Orders
Where fk_Customer = 1 And Date Between '20020101' and '20021231'
Group by Date, Code
This results in the following set:
Date Code Total
2002-01-22 00:00:00.000 Ru1 -2.00000
2002-01-28 00:00:00.000 Ru1 -1.00000
2002-04-06 00:00:00.000 Ru3 2.00000
2002-04-24 00:00:00.000 Ru1 -2.00000
2002-05-15 00:00:00.000 Ru1 1.00000
2002-05-16 00:00:00.000 Ru1 -1.00000
2002-08-06 00:00:00.000 Ru3 4.00000
Now I want a extra column with the cumulative Total up until that Date for the code in that record. So the result set would look like this:
Date Code Total CumTotal
2002-01-22 00:00:00.000 Ru1 -2.00000 -2.0000
2002-01-28 00:00:00.000 Ru1 -1.00000 -3.0000
2002-04-06 00:00:00.000 Ru3 2.00000 2.0000
2002-04-24 00:00:00.000 Ru1 -2.00000 -5.0000
2002-05-15 00:00:00.000 Ru1 1.00000 -4.0000
2002-05-16 00:00:00.000 Ru1 -1.00000 -6.0000
2002-08-06 00:00:00.000 Ru3 4.00000 6.0000
How can this be done in a set-oriented way?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only