1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| SELECT COUNT(DISTINCT UCLPRDDWH.DET_LIG_TRN.DWH_SEQ_NUM_IND), YEAR(DTE_TRNJ),DATEPART(WEEK,DTE_TRNJ)
FROM UCLPRDDWH.DET_LIG_TRN, UCLPRDDWH.DET_PDV, LDS_TMP_STATION_GEANT_TRIPLE, UCLPRDDWH.DET_PORTEUR
WHERE
UCLPRDDWH.DET_LIG_TRN.DWH_SEQ_NUM_IND = UCLPRDDWH.DET_PORTEUR.DWH_SEQ_NUM_IND
AND UCLPRDDWH.DET_PDV.COD_PDV_COM = 'CG' + RIGHT(LDS_TMP_STATION_GEANT_TRIPLE.COD_PDV_COM,3)
AND UCLPRDDWH.DET_LIG_TRN.DWH_SEQ_PDV = UCLPRDDWH.DET_PDV.DWH_SEQ_PDV
AND UCLPRDDWH.DET_LIG_TRN.DTE_TRNJ > '2008/12/31'
AND DWH_COD_TYPIND = 'A'
AND UCLPRDDWH.DET_PORTEUR.DWH_SEQ_NUM_IND IN (SELECT DISTINCT UCLPRDDWH.DET_LIG_TRN.DWH_SEQ_NUM_IND, YEAR(DTE_TRNJ),DATEPART(WEEK,DTE_TRNJ)
FROM UCLPRDDWH.DET_LIG_TRN, UCLPRDDWH.DET_PDV, LDS_TMP_STATION_GEANT_TRIPLE, UCLPRDDWH.DET_PORTEUR
WHERE UCLPRDDWH.DET_LIG_TRN.DWH_SEQ_NUM_IND = UCLPRDDWH.DET_PORTEUR.DWH_SEQ_NUM_IND
AND UCLPRDDWH.DET_PDV.COD_PDV_COM = LDS_TMP_STATION_GEANT_TRIPLE.COD_PDV_COM
AND UCLPRDDWH.DET_LIG_TRN.DWH_SEQ_PDV = UCLPRDDWH.DET_PDV.DWH_SEQ_PDV
AND UCLPRDDWH.DET_LIG_TRN.DTE_TRNJ > '2008/12/31'
AND DWH_COD_TYPIND = 'A' Group by YEAR(DTE_TRNJ),DATEPART(WEEK,DTE_TRNJ))
Group by YEAR(DTE_TRNJ),DATEPART(WEEK,DTE_TRNJ) |
Partager