Try this, but not really sure since the expected output is not entirely certain based on the thread

/*ID | Value

---------

1 | 19

2 | 90

3 | 20

4 | 8

5 | 9

*/

DECLARE @valuestab TABLE (ID INT,VALUE INT)

INSERT INTO @valuestab

( ID, VALUE )

VALUES ( 1,19

),(2,90),(3,20),(4,8),(5,9);

WITH CTE (ID,Value) AS

(

SELECT ID,

Value

FROM @valuestab

UNION ALL

SELECT a.id,

a.Value + b.Value

FROM @valuestab a

INNER JOIN CTE b

ON b.ID +1 = a.ID

)

SELECT ID, MAX(Value) AS Value

FROM CTE

GROUP BY ID