Do more with
UPDATE [STATISTICS]
SET TOTALS = T.Totals
FROM (SELECT CURRATE, REQPORT, TOTALS FROM MYVIEW) T
WHERE CURRDATE = XX
AND REQPORT = T.REQPORT
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
Premium Content
You need an Expert Office subscription to comment.Start Free Trial