1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
| SELECT ANEX.ANEX_NOM,
MAX(CASE WHEN ANEXCOM.DATE = {Param_Date_Lundi} THEN ANEX_NOM END) AS NOM1,
MAX(CASE WHEN ANEXCOM.DATE = {Param_Date_Lundi} THEN QUANTITE END) AS QUANT1,
MAX(CASE WHEN ANEXCOM.DATE = {Param_Date_Lundi} THEN ANEX_UNIT END) AS UNIT1,
MAX(CASE WHEN ANEXCOM.DATE = {Param_Date_Mardi} THEN ANEX_NOM END) AS NOM2,
MAX(CASE WHEN ANEXCOM.DATE = {Param_Date_Mardi} THEN QUANTITE END) AS QUANT2,
MAX(CASE WHEN ANEXCOM.DATE = {Param_Date_Mardi} THEN ANEX_UNIT END) AS UNIT2,
MAX(CASE WHEN ANEXCOM.DATE = {Param_Date_Mercredi} THEN ANEX_NOM END) AS NOM3,
MAX(CASE WHEN ANEXCOM.DATE = {Param_Date_Mercredi} THEN QUANTITE END) AS QUANT3,
MAX(CASE WHEN ANEXCOM.DATE = {Param_Date_Mercredi} THEN ANEX_UNIT END) AS UNIT3,
MAX(CASE WHEN ANEXCOM.DATE = {Param_Date_Jeudi} THEN ANEX_NOM END) AS NOM4,
MAX(CASE WHEN ANEXCOM.DATE = {Param_Date_Jeudi} THEN QUANTITE END) AS QUANT4,
MAX(CASE WHEN ANEXCOM.DATE = {Param_Date_Jeudi} THEN ANEX_UNIT END) AS UNIT4,
MAX(CASE WHEN ANEXCOM.DATE = {Param_Date_Vendredi} THEN ANEX_NOM END) AS NOM5,
MAX(CASE WHEN ANEXCOM.DATE = {Param_Date_Vendredi} THEN QUANTITE END) AS QUANT5,
MAX(CASE WHEN ANEXCOM.DATE = {Param_Date_Vendredi} THEN ANEX_UNIT END) AS UNIT5
FROM
ANEX, ANEXCOM
WHERE
ANEX.ANEX_CLE = ANEXCOM.ANEX_CLE
AND
ANEXCOM.ECOLE_CLE = {Param_Ecole_Cle}
AND
ANEXCOM.DATE BETWEEN {Param_Date_Lundi} AND {Param_Date_Vendredi}
GROUP BY
ANEX.ANEX_NOM |
Partager