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 RIA Unleashed (Nov. 2010) with:

abhay maini

Member since Aug 11, 2010

Recent Blog Comments By abhay maini

  • Using CASE Statements In A SQL UPDATE Query

    Posted on Sep 11, 2010 at 2:15 PM

    @Ben, @pinal Thanks Guys, I didnt realize this earlier. COALESCE should do the same. Cheerz... read more »

  • Using CASE Statements In A SQL UPDATE Query

    Posted on Aug 11, 2010 at 10:38 AM

    @ABHAY, NEVERMIND I GOT IT, btw i am using MERGE i hope the same logic can be applied for simple update aswell. UPDATE SET RTRMNT_FG = CASE WHEN TARGET.RTRMNT_FG IS NULL THEN SOURCE.RTRMNT_FG --UPDATE ONLY WHEN ITS NULL END , DT_OF_RTRMNT = SOURCE.DT_OF_RTRMNT , UPD_TS = GETDATE() th... read more »

  • Using CASE Statements In A SQL UPDATE Query

    Posted on Aug 11, 2010 at 10:27 AM

    What you wrote is fine. Tell me how will you write a sql where you have to update one field only if its null where as other fields should be updated at the same time with no condition. UPDATE TABLE SET A (only if its null)= B.a ,X= B.x ,Y = B.y... read more »