How would you do to transform a Column in a table from this: 

ColumnA   ColumnB
2           a
3           b
4           c
5           d
1           a

to this:

ColumnA          ColumnB
3                 a
6(=3+3)           b   
10(=4+3+3)        c   
15(=5+4+3+3)      d

I'm interested to see esp. what method you would pick.

sql sql-server sql-server-2008 cumulative-sum
Edit
Report