Work_period ‘lar arasında rapor taşımak

———— DURUMU INCELE ——–

SELECT WORK_PERIOD, TASKCODE, COUNT(dISTINCT PERIOD), COUNT(*)
FROM RI_REPORTS_204
WHERE ACT=1
GROUP BY WORK_PERIOD, TASKCODE
ORDER BY TASKCODE, WORK_PERIOD





—- ONCE ESKILERI SIL ———-
delete RI_REPORTS_204
WHERE WORK_PERIOD=’200703′ AND PERIOD IN (’200708′) AND TASKCODE IN (’10′, ‘….’)







—— YENI OLANI, APP-TO YAPILACAK YERE GETIR —————

UPDATE RI_rEPORTS_204
SET WORK_PERIOD=X.PERIOD,
PERIODREF=X.REFERENCE
FROM RI_PERIODS X
WHERE RI_REPORTS_204.WORK_PERIOD=’200708′ AND RI_REPORTS_204.PERIOD IN (’200708′) AND RI_REPORTS_204.TASKCODE IN () AND X.PERIOD=’200703′ AND X.ACT=1