Cumulative Total

[sathish kumar s]

Dear group,
how to write a single sql query to display the fields of a table with cumulative total.

table name - sales

fields - item_code, supplier_code, sales_amount

i need to display the result as
item_code, supplier_code, sales_amount, cumulative_sales_amount

the cumulative sales amount should be cumulative for all rows.

with advance thanks

--
Sathish Kumar.S
SpireTEK

[mmarovic]

See: http://www.sql-server-performance.co...ly_problem.asp

[sathish kumar s]

Thank you.
But the correlated query takes too much of time for 70,000 records.
I think using procedure do good.

Sathish Kumar.S
SpireTEK

[mmarovic]

If you read the article, you'll see that correlated query is not the solution recommended there. There are a few better solution mentioned there.