If you need decreasing sum, just reverse the condition T2.[ID] <= T1.[ID] as T2.[ID] >= T1.[ID] So it sums all items after and including the current.
For example the first line with T1.ID=1 sums whole table by condition T2.ID >= 1 that is true for all rows.