IF object_id('#tmp_sum') IS NOT NULL
    DROP TABLE #tmp_sum

go

CREATE TABLE #tmp_sum(ID INT IDENTITY PRIMARY KEY CLUSTERED, Deal money)

INSERT INTO #tmp_sum(Deal)
VALUES ( 100 )

INSERT INTO #tmp_sum(Deal)
VALUES ( 200 )

INSERT INTO #tmp_sum(Deal)
VALUES ( 20 )

INSERT INTO #tmp_sum(Deal)
VALUES ( 9 )

DECLARE @Deal MONEY

SET @Deal =  0 

--Вариант 1
SELECT t.ID, sum(tt.Deal)
FROM #tmp_sum t
    INNER JOIN #tmp_sum tt
    ON tt.ID <= t.ID
GROUP BY t.ID

--Вариант 2
UPDATE #tmp_sum
SET Deal = Deal + @Deal,
    @Deal = Deal + @Deal
    
SELECT * 
FROM #tmp_sum