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 31 32
|
WITH CTE AS (
SELECT
PA01 AS TYPE_ADH,
PA03 AS ANC_NUM_STUCT,
COUNT(ADIDEN) AS NB_ADH,
CASE
WHEN PA01 IN ('AD', 'PA') THEN '15'
WHEN PA01 IN ('FC', 'FS') THEN '22,5'
WHEN PA01 IN ('CS', 'NA') THEN 'NON-PART_NAT'
WHEN PA01 ='AB' THEN 'CETTE VENTE SERA FACTUREE'
END AS UNITE_PART_NATIONALE,
FROM
VUE_ADR AA
INNER JOIN VUE_CODAD BB ON AA.ADIDEN = BB.COIDEN
INNER JOIN VUE_ADHADM CC ON AA.ADIDEN = CC.ADM_IDEN
WHERE
ADM_DDU > '2014-12-31' AND PA03 LIKE '75%'
GROUP BY BB.PA01, BB.PA03
ORDER BY BB.PA01, BB.PA03
)
SELECT
TYPE_ADH
,ANC_NUM_STUCT
,NB_ADH
,UNITE_PART_NATIONALE
,CASE
WHEN PA01 IN ('AD', 'FC', 'FS', 'PA') THEN NB_ADH * UNITE_PART_NATIONALE
WHEN PA01 IN ('CS', 'NA') THEN '0'
WHEN PA01 ='AB' THEN 'A DETERMINER'
END AS TOTAL
FROM CTE |
Partager