CREATE TABLE #TEMP(ID INT IDENTITY(1,1), A INT)

INSERT INTO #temp 
SELECT 10 UNION ALL
SELECT 20 UNION ALL
SELECT 30 UNION ALL
SELECT 40 UNION ALL
SELECT 50 UNION ALL
SELECT 60 UNION ALL
SELECT 70 UNION ALL
SELECT 80 UNION ALL
SELECT 90 UNION ALL
SELECT 100

SELECT * FROM #temp

SELECT A.ID,
         MIN(A.A)as A,  
         SUM(ISNULL(B.A,0))as CUM_VALUE_OF_A
FROM
      #TEMP A
      INNER JOIN 
     #TEMP B
ON  A.ID    >=    B.ID
GROUP BY A.ID