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 CFUNITED 2010 (Landsdown, VA) with:

Gonzalo

Member since Mar 25, 2009

Recent Blog Comments By Gonzalo

  • Using CASE Statements In A SQL UPDATE Query

    Posted on Mar 25, 2009 at 4:35 PM

    CORRECTED CODE I have the following SQL statement that meets all the requirements of what I am trying to do… SELECT Diff_Adj, Case When Diff_Adj < 0 Then '-'+right ('00000000'+convert (varchar(10), convert (int, -Diff_Adj*100)), 9) Else right ('00... read more »

  • Using CASE Statements In A SQL UPDATE Query

    Posted on Mar 25, 2009 at 4:33 PM

    I have the following SQL statement that meets all the requirements of what I am trying to do… SELECT Diff_Adj, Case When Diff_Adj < 0 Then '-'+right ('00000000'+convert (varchar(10), convert (int, -Diff_Adj*100)), 9) Else right ('000000000'+convert... read more »