Smarter update possible

• well0549

  SSCrazy

  Points: 2259

  More actions

  July 3, 2003 at 7:08 am

  #159347

  We have the following situation.....

  Update TableA Set

  Field1 = (select Anotherfield1 from tableB where ID = 1)

  Field2 = (select Anotherfield2 from tableB where ID = 1)

  Field3 = (select Anotherfield3 from tableB where ID = 1)

  (etc etc..... fone for approx 14 fields)

  We cannot execute a stored procedure and the query has to handle this in one go........

  Is there anybody out there who knows a better way ?????

• NPeeters

  SSChampion

  Points: 12541

  More actions

  July 3, 2003 at 9:49 am

  #464086

  Try

  
  
  UPDATE TableA SET
  
  Field1 = tableB.Anotherfield1,
  
  Field2 = tableB.Anotherfield2,
  
  ...
  
  FROM
  
  tableB
  
  WHERE tableB.ID = 1