Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at BFusion / BFLEX 2009 (Bloomington, Indiana) with: Dan Wilson

Leon

Member since Dec 11, 2008

Recent Blog Comments By Leon

  • SQL COALESCE() Very Cool, But Slower Than ISNULL()

    Posted on Sep 29, 2006 at 2:37 PM

    COALESCE is actually very useful in certain situations. For example, if you had a table with two quantity columns and you wanted to sum the difference between them, you would do, select sum(coalesce(quanitty1, 0) - coalesce(quantity2, 0)) as difference If you didn't use coalesce, then the sum wil... read more »