SQL SELECT 후 다른 Table에 UPDATE 하는 방법 (MSSQL)

BEGIN TRAN

    UPDATE Users_job

    SET duty_cd=a.duty_cd, duty_name=a.duty_name, dpt_id=a.dpt_id

    FROM (SELECT user_id, duty_cd, duty_name, dpt_id
              FROM Users) A

    WHERE Users_job.user_id = A.user_id

IF @@ERROR = 0

    COMMIT

ELSE

    ROLLBACK