1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| SELECT DateDemande AS dateOperation, IDCPS AS IDCarte, IDUser AS IDUtilisateur, IDUtilisateur AS IDAgent, '6' AS IDOperation
FROM SUIVI.FIC
WHERE dateDemande IS NOT NULL
UNION ALL
SELECT DateReception AS dateOperation, IDCPS AS IDCarte, IDUser AS IDUtilisateur, IDUtilisateur AS IDAgent, '5' AS IDOperation
FROM SUIVI.FIC
WHERE DateReception IS NOT NULL
UNION ALL
SELECT DateDistribution AS dateOperation, IDCPS AS IDCarte, IDUser AS IDUtilisateur, IDUtilisateur AS IDAgent, '1' AS IDOperation
FROM SUIVI.FIC
WHERE dateDistribution IS NOT NULL
UNION ALL
SELECT DatePerte AS dateOperation, IDCPS AS IDCarte, IDUser AS IDUtilisateur, IDUtilisateur AS IDAgent, '2' AS IDOperation
FROM SUIVI.FIC
WHERE datePerte IS NOT NULL
UNION ALL
SELECT DateFinAttribution AS dateOperation, IDCPS AS IDCarte, IDUser AS IDUtilisateur, IDUtilisateur AS IDAgent, '7' AS IDOperation
FROM SUIVI.FIC
WHERE dateFinAttribution IS NOT NULL
UNION ALL
SELECT DateRestitution AS dateOperation, IDCPS AS IDCarte, IDUser AS IDUtilisateur, IDUtilisateur AS IDAgent, '4' AS IDOperation
FROM SUIVI.FIC
WHERE dateRestitution IS NOT NULL
ORDER BY dateOperation |
Partager