Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Rob Brooks-Bilson
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Rob Brooks-Bilson@styggiti )

Aakansha

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 »