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 cf.Objective() 2010 (Minneapolis, MN) with: Doug Hughes and Ezra Parker and Dan Wilson and John Mason and Jason Dean and Luis Majano and Mark Mandel and Brian Kotek and Wil Genovese and Rob Brooks-Bilson and Andy Matthews and Simeon Bateman and Ray Camden and Chris Rockett and Joe Bernard and Dan Skaggs and Byron Raines and Barney Boisvert and Simon Free and Steve 'Cutter' Blades and Seth Bienek and Katie Bienek

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 »