update t1
set totals =t2.totals
from STATISTICS t1
INNER JOIN (SELECT CURRATE, REQPORT, TOTALS FROM MYVIEW) t2 ON t1.CURRDATE = t2.currate AND t1.report = t2.reqport
UPDATE s
SET TOTALS = v.TOTALS
FROM [STATISTICS] s
INNER JOIN MYVIEW v ON s.REQPORT = v.REQPORT
WHERE s.CURRDATE = XX
Open in new window