1 2 3 4 5 6 7 8 9 10 11 12 13 14
| CASE
WHEN CONVERT(DATETIME, MIN([HR_DEB]))<'07:00' THEN 'Avant 7h'
WHEN CONVERT(DATETIME, MIN([HR_DEB]))>='07:00' and CONVERT(DATETIME, MIN([HR_DEB]))<'07:30' THEN 'Entre 7h et 7h30'
WHEN CONVERT(DATETIME, MIN([HR_DEB]))>='07:30' and CONVERT(DATETIME, MIN([HR_DEB]))<'08:00' THEN 'Entre 7h30 et 8h'
WHEN CONVERT(DATETIME, MIN([HR_DEB]))>='08:00' and CONVERT(DATETIME, MIN([HR_DEB]))<'08:30' THEN 'Entre 8h et 8h30'
WHEN CONVERT(DATETIME, MIN([HR_DEB]))>='08:30' and CONVERT(DATETIME, MIN([HR_DEB]))<'09:00' THEN 'Entre 8h30 et 9h'
WHEN CONVERT(DATETIME, MIN([HR_DEB]))>='09:00' and CONVERT(DATETIME, MIN([HR_DEB]))<'09:30' THEN 'Entre 9h et 9h30'
WHEN CONVERT(DATETIME, MIN([HR_DEB]))>='09:30' and CONVERT(DATETIME, MIN([HR_DEB]))<'10:00' THEN 'Entre 9h30 et 10h'
WHEN CONVERT(DATETIME, MIN([HR_DEB]))>='10:00' and CONVERT(DATETIME, MIN([HR_DEB]))<'10:30' THEN 'Entre 10 et 10h30'
WHEN CONVERT(DATETIME, MIN([HR_DEB]))>='10:30' and CONVERT(DATETIME, MIN([HR_DEB]))<'11:00' THEN 'Entre 10h30 et 11h'
WHEN CONVERT(DATETIME, MIN([HR_DEB]))>='11:00' and CONVERT(DATETIME, MIN([HR_DEB]))<'11:30' THEN 'Entre 11h et 11h30'
WHEN CONVERT(DATETIME, MIN([HR_DEB]))>='11:30' and CONVERT(DATETIME, MIN([HR_DEB]))<'12:00' THEN 'Entre 11h30 et 12h'
ELSE 'Après 12h'
END as Tranche_horaire |
Partager