Query for running total in SQL Server

Using window functions (partition by) will speed up the process:

SELECT Val, 
SUM(Val) OVER (Partition BY [YourPartitionValue] 
                  Order BY [OrderColumn] as CumulativeSum
FROM [Table]

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

Elina Blank

Software Developer (Senior) The Code Project
United States

Elina joined the Code Project team as a software developer in order to make the site run even smoother than it is now. She will also take care of making wishes and promises on the site improvements come to the light sooner than later. When not at work, she enjoys being with her family and wishes there will be at least 30 hours in a day Smile | :)

Article Top

Poor

Excellent

Add a reason or comment to your vote: x
Votes of 3 or less require a comment

Alternative to Query for running total in SQL Server

Using window functions (partition by) will speed up the process:SELECT Val, SUM(Val) OVER (Partition BY [YourPartitionValue] Order BY [OrderColumn] as CumulativeSumFROM [Table]

Type	Tip/Trick
Licence	CPOL
First Posted	24 Aug 2011
Views	1,206
Bookmarked	1 time

SQL-Server

		9,932,132 members (38,895 online) Visit CodeProject.TV Discuss CodeProject.TV Sign in Email Password Forgot your password? Sign in using

Query for running total in SQL Server

License

About the Author

Comments and Discussions