1
2
3
4
5
6
7
8
9
10
11
12
13
14
| UPDATE FTRBORDEREAU
SET TRBORDEREAU_DESAC=SYSDATE
WHERE (TRBORDEREAU_VTADRLIV_CLE,TRBORDEREAU_EDITION) IN
(SELECT TRBORDEREAU_VTADRLIV_CLE,TRBORDEREAU_EDITION
FROM FTRBORDEREAU
WHERE TRBORDEREAU_TRTRANSP_CLE = 16
AND TRBORDEREAU_EDITION BETWEEN to_date('29/03/2004', 'DD/MM/YYYY')
AND to_date('30/03/2004', 'DD/MM/YYYY')
GROUP BY TRBORDEREAU_VTADRLIV_CLE,TRBORDEREAU_EDITION
HAVING COUNT(*) >1)
AND TRBORDEREAU_DESAC IS NULL
AND TRBORDEREAU_NB IS NULL
AND TRBORDEREAU_EDITION BETWEEN to_date('29/03/2004', 'DD/MM/YYYY')
AND to_date('30/03/2004', 'DD/MM/YYYY') |
