Bonjour,
La requête ci-dessous m'affiche deux lignes par matricule :
DAT/MATRI/NOM/MOTIF/CODECRIT/CODEQUAL
01/10/2018/0001/DURAND/JOUR/SAPB/CHEF
01/10/2018/0001/DURAND/JOUR/SAPB/ADJOINT
01/10/2018/0002/DURAND/NUIT/null/CHEF
01/10/2018/0002/DURAND/NUIT/null/null
...
Je souhaiterais faire un affichage comme ci-dessous :
DAT/MATRI/NOM/MOTIF/CODECRIT/CODEQUAL/CODEQUAL2
01/10/2018/0001/DURAND/JOUR/SAPB/CHEF/ADJOINT
01/10/2018/0002/DURAND/NUIT/null/CHEF/null
...
Est-ce possible de transposer ?
Merci pour votre aide.
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15 SELECT T1.DAT as DAT,T1.MATRI AS MATRI,T2.NOMPRE AS NOM,T1.MOTIF AS MOTIF, T3.CODECRIT as CODECRIT, T4.CODEQUAL AS CODEQUAL FROM T1 LEFT OUTER JOIN T2 ON T1.MATRI = T2.MATRI LEFT OUTER JOIN T3 ON T2 = PLPEMCRI.MATRI AND T3.CODECRIT = 'SAPB' AND T3.DATFIN = '31/12/2099' LEFT OUTER JOIN T4 ON T2.MATRI = T4.MATRI AND T4.CODEQUAL = 'CHEF' AND T4.DATFIN = '31/12/2099' WHERE T1.MOTIF in ('JOUR','NUIT', 'AM', 'MATIN') AND T1.DAT >= '01/10/2018' AND T1.DAT <= '31/10/2018' UNION SELECT T1.DAT as DAT,T1.MATRI AS MATRI,T2.NOMPRE AS NOM,T1.MOTIF AS MOTIF, T3.CODECRIT as CODECRIT, T4.CODEQUAL AS CODEQUAL FROM T1 LEFT OUTER JOIN T2 ON T1.MATRI = T2.MATRI LEFT OUTER JOIN T3 ON T2 = PLPEMCRI.MATRI AND T3.CODECRIT = 'SAPB' AND T3.DATFIN = '31/12/2099' LEFT OUTER JOIN T4 ON T2.MATRI = T4.MATRI AND T4.CODEQUAL = 'ADJOINT' AND T4.DATFIN = '31/12/2099' WHERE T1.MOTIF in ('JOUR','NUIT', 'AM', 'MATIN') AND T1.DAT >= '01/10/2018' AND T1.DAT <= '31/10/2018'
Partager