update cas set cas.DocumentHeaderIdOfTransferredForForm = apply.Id
from dbo.CaseTransfer cas
join dbo.DocumentHeader noti
on noti.Id = cas.DocumentHeaderId
JOIN dbo.DocumentHeader apply ON noti.CheckMissionId=apply.CheckMissionId
update cas set cas.DocumentHeaderIdOfTransferredForForm = apply.Id
from dbo.CaseTransfer cas
join dbo.DocumentHeader noti
on noti.Id = cas.DocumentHeaderId
JOIN dbo.DocumentHeader apply ON noti.CheckMissionId=apply.CheckMissionId