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 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96
| SELECT
S.[STE]
,S.[CODE_CLT]
,S.[NOM_CLT]
,SUM(S.CA_YTDn) as CA_YTDn
,SUM(S.CA_YTDn_1) as CA_YTDn_1
,SUM(S.CA_MTDn) as CA_MTDn
,SUM(S.CA_MTDn_1) as CA_MTDn_1
FROM
(
Select
[STE]
,[CODE_CLT]
,[NOM_CLT]
,SUM([MONTANT_HT]) as CA_YTDn
,0 as CA_YTDn_1
,SUM([MONTANT_HT]) as CA_MTDn
,0 as CA_MTDn_1
from[dbo].[STAT_MARQUES_CLIENTS]
where ([ANNEE] = !PARAM_ANNEE and [MOIS] = !PARAM_MOIS)
group by
[STE]
,[CODE_CLT]
,[NOM_CLT]
union
Select
[STE]
,[CODE_CLT]
,[NOM_CLT]
,0 as CA_YTDn
,SUM([MONTANT_HT]) as CA_YTDn_1
,0 as CA_MTDn
,SUM([MONTANT_HT]) as CA_MTDn_1
from[dbo].[STAT_MARQUES_CLIENTS]
where ([ANNEE] = !PARAM_ANNEE-1 and [MOIS] = !PARAM_MOIS)
group by
[STE]
,[CODE_CLT]
,[NOM_CLT]
union
Select
[STE]
,[CODE_CLT]
,[NOM_CLT]
,SUM([MONTANT_HT]) as CA_YTDn
,0 as CA_YTDn_1
,0 as CA_MTDn
,0 as CA_MTDn_1
from[dbo].[STAT_MARQUES_CLIENTS]
where ([ANNEE] = !PARAM_ANNEE and [MOIS] < !PARAM_MOIS)
group by
[STE]
,[CODE_CLT]
,[NOM_CLT]
union
Select
[STE]
,[CODE_CLT]
,[NOM_CLT]
,0 as CA_YTDn
,SUM([MONTANT_HT]) as CA_YTDn_1
,0 as CA_MTDn
,0 as CA_MTDn_1
from[dbo].[STAT_MARQUES_CLIENTS]
where ([ANNEE] = !PARAM_ANNEE-1 and [MOIS] < !PARAM_MOIS)
group by
[STE]
,[CODE_CLT]
,[NOM_CLT]
) as S
where
S.CODE_CLT in ('C0000002','C0000009')
Group by
S.[STE]
,S.[CODE_CLT]
,S.[NOM_CLT]
Order by
S.[STE]
,S.[CODE_CLT]
,S.[NOM_CLT] |
Partager