Posted by Tom Moreau on 10/01/05 11:40

I agree. It's a real challenge trying to divine the business spec from the
data! As it turns out, I'm trying to enter my accounting info into
QuickBooks and we have been the victims of double-entry bookkeeping. :-(

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns976FA19DB42F6Yazorman@127.0.0.1...
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]