|
|
Posted by Erland Sommarskog on 09/28/95 11:40
Tom Moreau (tom@dont.spam.me.cips.ca) writes:
> What business rules do you have? Based on your data, it looked like you
> wanted SUM(Credit - Debit) but the desired output you posted earlier
> doesn't match this.
That sum is hopefully always 0, or else something is really broken!
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|