I have exported data from table T (target table) to Excel and manually
changed some columns. Now I want to persist those values back into table T.

So I import the csv file into a staging table S that has the same structure
as T, let's say both look like
key (INT) name (CHAR) qty (INT)

What is the best way to update the rows of T from S?

thanks,
Deac

update T SET T.name=S.Name, T.Qty=S.Qty
FROM T, S
WHERE T.id=S.id

Francesco Anti

"deacdb" <deacdb2 (AT) hotmail (DOT) com> wrote