Posted by Erland Sommarskog on 10/01/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

[Back to original message]