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