update issue

• Best-330874

  SSCrazy

  Points: 2350

  More actions

  February 28, 2007 at 10:19 pm

  #176198

  Hi,

      i need help on this. i have a table called as Claim_Counts which has a datatype int.i want to update this column in the table with a FLAG with the same value (True) for all.

• AMIT GUPTA-263376

  SSCarpal Tunnel

  Points: 4244

  More actions

  March 1, 2007 at 2:19 am

  #692521

  Please clear ur requirement!!

  If u want to run the update statement u can use it...

  Update table_name set Claim_Count=(case when Flag=true then 1 else 0 end)

  Otherwise clear ur requirement.

   

  Regards ,

  Amit Gupta