update stor.T_STORAGE stor
set EhrRusMdr308 = pharm.EhrRusMdr308
from APS.T_PHARMACY_ISSUE_PLACE pharmacy_ip 
join APS.T_PHARMACY pharm on pharm.Code = pharmacy_ip.Pharmacy
where stor.IssuePlace = pharmacy_ip.IssuePlaceId;