refer to this post...

http://sqlsaga.com/sql-server/how-to-calculate-running-totals-in-sql-server/[/url]

step by step explained...