Freitag, 17. Mai 2013

UPDATE table with values from another table using inner join

update t1
set baseid = tv.ID
output deleted.baseid del, inserted.baseid i
from
tmp.Norm t1 inner join dbo.v_Norm tv
on t1.baseid = tv.tmpid

Keine Kommentare: