How about:

IF OBJECT_ID('MyTable') IS NOT NULL

DROP TABLE MyTable

GO

SELECT * INTO MyTable

FROM (VALUES(1,19), (2,90), (3,20), (4,8), (5, 9)) AS M(ID, VALUE)

GO

SELECTm.Id, SUM(m2.Value)

FROMMytable m

JOINMytablem2ON m2.ID <= m.id

GROUP BY m.Id