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 2005 Forums
 Transact-SQL (2005)
 subtract command

Author  Topic 

sfjtraps
Yak Posting Veteran

65 Posts

Posted - 2009-06-18 : 09:04:39
SELECT ((SUM(column1) - (SUM(column2))) AS theData

This select statement is giving me errors. I'm not sure I'm using the subtracting syntax correctly, does anyone have any ideas. Thank you.

sfjtraps
Yak Posting Veteran

65 Posts

Posted - 2009-06-18 : 09:07:10
Nevermind, I got it, my parentheses were goofed up.
Go to Top of Page
   

- Advertisement -