1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| SELECT CONVERT(VARCHAR,'INTERVENTIONS') Nature,
YEAR(I.DH_DEBUT_INTER) AnIntN,
DATENAME(MONTH,I.DH_DEBUT_INTER) MoisIntN,
COUNT(RIGHT(I.ID_INTERVENTION,5)) NbreIntN
FROM OPS_INTERVENTION I
INNER JOIN OPS_CENTRE C ON C.ID_CENTRE = I.ID_CENTRE_PRINC
WHERE LEFT(C.LIB_CENTRE,5) NOT IN ('CTRAU','DIREC','ET.MA', 'DITL ')
AND LEFT(C.LIB_CENTRE,2) NOT LIKE 'Z-'
AND YEAR(I.DH_DEBUT_INTER) BETWEEN 2016 AND 2022
AND DATENAME(MONTH,I.DH_DEBUT_INTER) = 'janvier'
GROUP BY YEAR(I.DH_DEBUT_INTER), LEFT(CONVERT(VARCHAR,I.DH_DEBUT_INTER,112),6), DATENAME(MONTH,I.DH_DEBUT_INTER) |
Partager