UPDATE a set a.ProcessStatus ='C', a.ProcessTime =getdate(), a.ExecDate = b.ExecDate
FROM transport AS a ,vi_Surgery AS b
WHERE a.IdHospSurgery = b.IdHospSurgery AND b.ExecDate IS NOT NULL
AND b.ExecDate <>'1900-01-01 00:00:00.000' AND a.ProcessStatus ='P'