Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at Ellen's Stardust Diner (New York City) with: Colin Silverberg and Carol Loffelmann and Daniel Silverberg
Ben Nadel at Ellen's Stardust Diner (New York City) with: Colin Silverberg , Carol Loffelmann ( @Mommy_md ) , and Daniel Silverberg

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 »