Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.

Corey G

Member since Dec 11, 2009

Recent Blog Comments By Corey G

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

    Posted on Dec 11, 2009 at 10:35 AM

    Thanks, was looking for this with aggregates. Another nice use is for the div by zero issue: /isnull(nullif( denominator ,0),1) which returns 1 instead of 0 to divide by in case you want to avoid a filter within the WHERE section.... read more »