Madhivanan-208264 (9/7/2010)
Have a million row table and do running total using a triangular join
select col,
(select sum(col) from table as t1 where t1.pkcol<=t2.pkcol) as run_sum
from table as t2
Heh... ya beat me to it, Madhivanan.
--Jeff Moden
Change is inevitable... Change for the better is not.