Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Mike Collins and Elishia Dvorak
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Mike Collins@collinsmikej ) and Elishia Dvorak@elishtweet )

Moughees

Member since Aug 28, 2012

Recent Blog Comments By Moughees

  • SQL Aggregates Support CASE Statements

    Posted on Aug 28, 2012 at 8:55 AM

    I need help for below mention query, can some one help me :), really stuck with this query. SELECT CASE appresptime WHEN appresptime >= 0 AND appresptime <= 5 THEN '0-5 Sec' -- WHEN (t.appresptime > 5) THEN --'5 Above' ELSE 'normal' END CASE, round(t.appresptime / 1000, 0), count(t.id) fro... read more »