I have been using MS SQL 2000 for about 7 years now... but I had to look up NULLIF in books online to find out what it did.
There is always an easier way. >>> "Mike Kear" <[EMAIL PROTECTED]> 08/05/2007 3:30 pm >>> That did the trick, thanks Scott. I was trying to make it too complicated for myself. "Case" was the answer. -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 5/8/07, Scott Thornton <[EMAIL PROTECTED]> wrote: > > Hi, > > This is how I might do it in SQL Server: > > SELECT > > SUM(CASE WHEN deliverymethod = 'F' THEN > 1 > ELSE > 0 > END) AS FAXES, > SUM(CASE WHEN deliverymethod = 'E' THEN > 1 > ELSE > 0 > END) AS EMAILS > FROM > EReferralDailyMailoutHistory g INNER JOIN > DeliveryStatusMaster d ON > g.deliverystatus = d.statuscode > AND > g.deliverydate > #createodbcdate(arguments.argsStartDate)# > AND > g.deliverydate < #createodbcdate(arguments.argsEndDate)# > > > perhaps this will give you an idea of an alternate method of using NULLIF and > are now able to find the Oracle equivlalent of CASE. > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
