Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Cumulative Qry

Author  Topic 

empire
Starting Member

40 Posts

Posted - 2002-03-04 : 12:24:50
Im drawing a blank on this one...

Table
Value / YearMonth
10 200201
10 200202
10 200203
...

I need to qry cumulative values so that I end up with
10 200201
20 200202
30 200203
...

Any Ideas?

Programmers are simple devices, put caffeine in, and get code out.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-03-04 : 12:26:49
Garth has an article on running totals that should help you out:

http://www.sqlteam.com/item.asp?ItemID=3856

Go to Top of Page

empire
Starting Member

40 Posts

Posted - 2002-03-04 : 12:31:41
Thanks for the link, thats what I was looking for.
(And upon searching *again* myself, wondered how I missed the article)


Programmers are simple devices, put caffeine in, and get code out.
Go to Top of Page
   

- Advertisement -