Sunday, 11 November 2012

TSQL update sample using Join (Update multiple rows)



Update PA
SET PA.ActionID= A.ID
FROM ActionDates PA
LEFT JOIN Action A ON PA.Action = A.Name
AND PA.PhaseID=A.PhaseID

No comments:

Post a Comment