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
 Transact-SQL (2000)
 SQL

Author  Topic 

vijay6669
Starting Member

1 Post

Posted - 2002-04-26 : 18:35:46
Hi, I have a table with two columns named F1 and F2. it has the data 10 1000 , 12 200 , 15 300 . I need the sum of the column2 in the third column of Select query. i.e output may look like 10 1000 1500 , 12 200 1500 , 15 300 1500 .

Any help , greatly appreciated.

thanks







Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-04-26 : 21:16:04
Hi

Do you mean you want to keep a running total ?
We have an article for that here http://www.sqlteam.com/item.asp?ItemID=3856

Hope that helps

Damian
Go to Top of Page
   

- Advertisement -