SQL Server 2005 – Fast Running Totals solution with ordered CTE update

The Running Totals problem is as old as accounting. This is the fastest Running Totals solution using ordered Common Table Expressions (CTE) direct update feature in SQL Server 2005 and up.