65.9K
CodeProject is changing. Read more.
Home

Query for running total in SQL Server

starIconstarIconstarIconstarIconstarIcon

5.00/5 (1 vote)

Aug 25, 2011

CPOL
viewsIcon

9481

I guess this is more faster:SELECT T1.Field1, SUM(T2.Field1) FROM [Table] T1, [Table] T2WHERE T1.Field1 >= T2.Field1GROUP BY T1.Field1