Good article about running totals and need to store previous row values
On other day i am supposed to work on balance sheet calculations . I am literally dumb in such accounting things. I struggled get the ending balance, opening balance and carry forward values. I sterched my hand to get help from jeff moden( sql server central.com) He gave such a good idea which absoultely master piece.
Here is the link of it. Read it
http://www.sqlservercentral.com/articles/T-SQL/68467/
Here is the link of it. Read it
http://www.sqlservercentral.com/articles/T-SQL/68467/