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
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:
Kommentar veröffentlichen