Search SSWUG.ORG:



DATABASES

Conditional Aggregates This is an off-site link.  Please review our Terms of Service for additional information.


(Matt Bowler) The Problem: A legacy table contains amounts and a char column indicating whether the amount is a credit or a debit. We want an aggregate (over a given range) of the amounts. We need to add the credits and subtract the debits.

Read this article..







comments powered by Disqus