You can combine the PARTITION BY and ORDER BY clauses in #SQL window functions This splits the rows into groups for each partitioning value Then gets the running total within each group. By default, this is rows with a sort value less than or equal to the group's current row