Community Member Profile

Dan Farrell
Member since Dec 29, 2010

Recent Blog Comments By Dan Farrell

  • SQL COUNT( NULLIF( .. ) ) Is Totally Awesome

    Posted on Dec 29, 2010 at 9:49 PM

    >sum(case when paytype = 1 then amount else 0 end) as bpay, >sum(case when paytype = 2 then amount else 0 end) as paypal, >sum(case when paytype = 3 then amount else 0 end) as ccard For the record, a better way to do conditionals inside sums and counts might be: su... read more »

Member Account Kinky Solutions Shop
  • Help Wanted - Find Your Next ColdFusion Job
InVision App - Prototyping Made Beautiful With Prototyping Tools