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)
 How do I reference the sum ...

Author  Topic 

PeterG
Posting Yak Master

156 Posts

Posted - 2003-10-27 : 17:08:48
Select txtAccountNum, curTransacAmnt
From Transactions
Where txtInternetnum = '9532'
ORDER BY txtAccountNum
COMPUTE SUM(curTransacAmnt) BY txtAccountNum

PeterG
Posting Yak Master

156 Posts

Posted - 2003-10-27 : 17:10:14
pls ignore.
Go to Top of Page

mohdowais
Sheikh of Yak Knowledge

1456 Posts

Posted - 2003-10-28 : 01:16:30
Two minutes? The powers of this forum are certainly getting stronger...[:d]

Owais


Make it idiot proof and someone will make a better idiot
Go to Top of Page
   

- Advertisement -