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
| select a12.XXX_ID XXX_ID,
max(a12.XXX_NOM) XXX_NOM,
a12.VVV_ID VVV_ID,
max(a12.VVV_NOM) VVV_NOM,
a11.HHH_ID HHH_ID,
max(a12.HHH_NOM) HHH_NOM,
a12.TTT_ID TTT_ID,
max(a12.TTT_CODE) TTT_CODE,
max(a12.TTT_NOM) TTT_NOM,
a14.MOIS_ID MOIS_ID,
max(a14.MOIS_DE) MOIS_DE,
max(a14.MOIS_DE_AN) MOIS_DE_AN,
sum(a11.NB_A) WJXBFS1,
sum(a11.NB_B) WJXBFS2
from T_FAIT_PLANNING_REL a11
join T_DIM_HHH a12
on (a11.HHH_ID = a12.HHH_ID)
join T_DIM_VVV a13
on (a12.VVV_ID = a13.VVV_ID)
cross join T_DIM_MOIS a14
where (a14.MOIS_ID between ((DATEPART(YEAR, DATEADD(MM, -11, CONVERT (date, GETDATE()))) * 100) + DATEPART(MONTH, DATEADD(MM, -11, CONVERT (date, GETDATE())))) and ((DATEPART(YEAR, DATEADD(MM, 0, CONVERT (date, GETDATE()))) * 100) + DATEPART(MONTH, DATEADD(MM, 0, CONVERT (date, GETDATE()))))
and a12.XXX_ID in (14)
and a12.TTT_ID in (5457))
group by a12.XXX_ID,
a12.VVV_ID,
a11.HHH_ID,
a12.TTT_ID,
a14.MOIS_ID |
Partager