update Data from Temp

• burahdi

  Old Hand

  Points: 350

  More actions

  July 6, 2004 at 6:58 pm

  #152213

  Hi

  Can you please help me with a TSql statement to update data from a temp table to a SQL table.

  Basically have a temp table and need to use the values in one column in this table and update data in the live table based on certain criteria, simple.

  Your solution appreciated.

  Thanks

  Dinesh

• TriggerMe

  SSChampion

  Points: 11752

  More actions

  July 6, 2004 at 7:23 pm

  #513542

  Some sample code from you would make this easier however, it goes something like this;

  UPDATE Table SET Column = T.Column

  FROM TempTable T INNER JOIN Table X ON T.Pkey = X.Pkey

  WHERE Criteria  = or <> or whatever you wish to do

  ---

  Kindest Regards,