update VS4TARAppointment set TARAEmployeeName=(SELECT Tempfullname from vs4temployee where VS4TARAppointment.TARATEmpCode=vs4temployee.TEmpCode)
WHERE TARAEmployeeName='' or TARAEmployeeName is NULL
GO