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)
 Column sumary

Author  Topic 

nfsoft
Starting Member

36 Posts

Posted - 2004-07-05 : 12:41:21
I don't know if that is the correct name to it.
I need a column in a view of something like a sales table that resumes the subsum of the rows above.
ex:

name value sum
xpto 2.1 2.1
abcd 1.3 3.4
abcx 1.0 4.4
abcy 1.3 4.7

then base table is Sales(name, value)...

Can this be done? who?
I can't find a solution except by using a cursor....

Tanks



Nuno Ferreira

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2004-07-05 : 13:50:09
see your other thread: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=37078

Corey
Go to Top of Page
   

- Advertisement -