update ForeignProxyDisinfection set sterilizationUserCode = (select top 1 name from SS_USERS where fullName = ForeignProxyDisinfection.sterilizationUser) where sterilizationUser is not null and sterilizationUserCode is not null and sterilizationUserCode not in (select name from SS_USERS where fullName = sterilizationUser);