for the sample data it looks like this
;With CTE
AS
(
SELECT Field1,Field2,Field3,Field1 + Field2+ Field3 AS Total,
ROW_NUMBER() OVER (ORDER BY Field1) AS Seq
FROM Table
)
SELECT COALESCE(c2.Total,c1.Field1),c1.Field2,c1.field3,COALESCE(c2.Total,c1.Field1)+ c1.Field2 + c1.Field3 AS [Sum]
FROM CTE c1
LEFT JOIN CTE c2
ON c2.Seq= c1.Seq-1
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
sql query
Posted - 08/11/2012 : 05:10:53
