How to get a running total in SQL without using cursor?

Asked Apr 25 '14 at 12:48

Active Apr 25 '14 at 13:16

Viewed 84 times

I have a problem mentioned below

wkSales    ytdSale      
2839        15513      
2925        18202      
2705        20693      
2643        22499      
2515        24688      
1999        26128

I want to add wkSales of second row to ytdSales of first row and show their addition in second Row of ytdSale Column how can i achieve this in sql server 2008 please help me

edited Apr 25 '14 at 13:16

asked Apr 25 '14 at 12:48

akshay

1

You need to use [lead](http://technet.microsoft.com/en-us/library/hh213125.aspx). – abhi Apr 25 '14 at 12:53
Sorry abhi and all I forgot to mention that i am using sql server 2008 – akshay Apr 25 '14 at 13:02
Sorry. Lead and Lag are available only in Sql server 2012. I will have to find something else. – abhi Apr 25 '14 at 13:03
You don't seem to have a column that allows us to sanely define "first", "second", etc. Do you in fact have one or more such columns (e.g. a date, perhaps)? – Damien_The_Unbeliever Apr 25 '14 at 13:07
there are good answers... I'm going to point to one big discussion here on SO... – Mike M Apr 25 '14 at 13:23
1

http://stackoverflow.com/questions/11310877/calculate-running-total-running-balance/11313533#11313533 – Mike M Apr 25 '14 at 13:24

How to get a running total in SQL without using cursor?

0 Answers0