SELECT t1.DayCount, t1.Sales, SUM(t2.Sales) AS suma

FROM dbo.Sales t1

INNER JOIN Sales t2 ON t1.DayCount >= t2.DayCount

GROUP BY t1.DayCount, t1.Sales

ORDER BY t1.DayCount

DECLARE @SalesTbl TABLE (DayCount SMALLINT, Sales money, RunningTotal money)

 

DECLARE @DayCount SMALLINT,

        @Sales money,

        @RunningTotal money

 

SET @RunningTotal = 0

 

DECLARE rt_cursor CURSOR

SELECT DayCount, Sales

FROM tSales

ORDER BY DayCount

 

OPEN rt_cursor

 

FETCH NEXT FROM rt_cursor INTO @DayCount,@Sales

 

WHILE @@FETCH_STATUS = 0

 BEGIN

 SET @RunningTotal = @RunningTotal + @Sales

 INSERT @SalesTbl VALUES (@DayCount,@Sales,@RunningTotal)

 FETCH NEXT FROM rt_cursor INTO @DayCount,@Sales

 END

 

CLOSE rt_cursor

DEALLOCATE rt_cursor

 

SELECT * FROM @SalesTbl