See some of the ways to produce running totals, including new functionality in SQL Server 2012.

Tip : SQL Server Queries With Hints