Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at cf.Objective() 2014 (Bloomington, MN) with: Dave Ferguson and Simon Free and Tim Cunningham and Jason Dean
Ben Nadel at cf.Objective() 2014 (Bloomington, MN) with: Dave Ferguson@dfgrumpy ) , Simon Free@simonfree ) , Tim Cunningham@TimCunningham71 ) , and Jason Dean@JasonPDean )


Member since May 2, 2010

Recent Blog Comments By Aakansha

  • Using NULLIF() To Prevent Divide-By-Zero Errors In SQL

    Posted on May 2, 2010 at 1:36 AM

    Hi, Excellent find! Using this I soved my problem. For e.g sum(objid)/nullif(count(units_purch),0) where count(units_purch) return 0 value. However I've one question can I solve this problem using CASE statement. If yes, then how? Thanks in advance! Regards, Aakansha... read more »