UPDATE with INNER JOIN
begin tran
UPDATE
d
SET d.guid = pd.guid
FROM TableToBeUpdated AS d
INNER JOIN TableToGetDataFrom AS pd ON pd.ID = d.TableToGetDataFromID
where
pd.SomeCondition = TRUE
commit tran
UPDATE
d
SET d.guid = pd.guid
FROM TableToBeUpdated AS d
INNER JOIN TableToGetDataFrom AS pd ON pd.ID = d.TableToGetDataFromID
where
pd.SomeCondition = TRUE
commit tran
Comments
Write the first comment
Leave a trace
Post being viewed right now
