Subsums in SQL Server 2000

Question

Is there any nice way to get subsums in one query for data like this in sql server 2000?

Input:
Date       Value
2008-06-20 10
2008-08-20 20
2008-10-05 5
2008-10-09 30

Desired output:
10    --sum of 1st value
30    --sum of 1st and 2nd values..
35
65

Answer 1

This article covers your question (three times actually!). Interesting that the elegant approach is the slowest.

Answer 2

You'll also find this link useful as it describes how to calculate a running total without using a cursor.