UPDATE t
SET COMPANY_ID=(select top 1 ID FROM TEMP_SERVICE WHERE oldid=t.COMPANY_ID)
from HOT_ORDER t
WHERE NEWHOTID=157 AND COMPANY_ID>0
SET COMPANY_ID=(select top 1 ID FROM TEMP_SERVICE WHERE oldid=t.COMPANY_ID)
from HOT_ORDER t
WHERE NEWHOTID=157 AND COMPANY_ID>0
UPDATE HOT_ORDER
SET COMPANY_ID=T.ID
FROM TEMP_SERVICE T WHERE T.oldid=HOT_ORDER.COMPANY_ID
AND HOT_ORDER.NEWHOTID=157 AND HOT_ORDER.COMPANY_ID>0
SET COMPANY_ID=( select ID FROM TEMP_SERVICE WHERE oldid=COMPANY_ID)
WHERE NEWHOTID=157 AND COMPANY_ID>0
SET COMPANY_ID=(ID FROM TEMP_SERVICE WHERE oldid=COMPANY_ID)
WHERE WHERE NEWHOTID=157 AND COMPANY_ID>0
UPDATE HOT_ORDER
SET COMPANY_ID=(SELECT TOP 1 ID FROM TEMP_SERVICE WHERE oldid=COMPANY_ID)
WHERE NEWHOTID=157 AND COMPANY_ID>0--STEP 2
UPDATE HOT_ORDER
SET COMPANY_ID=T.ID FROM TEMP_SERVICE TS WHERE TS.oldid=HOT_ORDER.COMPANY_ID
AND HOT_ORDER.NEWHOTID=157 AND HOT_ORDER.COMPANY_ID>0