1 2 3 4 5 6 7 8 9 10
| SELECT ETB
,TRANCHE_HORAIRE
,DATECR
,CASE WHEN DATEPART(DW,DATECR)=1 THEN DATEDIFF(DAY, -7, @DateFin)/7-DATEDIFF(DAY, -6, @DateDebut)/7
WHEN DATEPART(DW,DATECR)=2 THEN DATEDIFF(DAY, -6, @DateFin)/7-DATEDIFF(DAY, -5, @DateDebut)/7
WHEN DATEPART(DW,DATECR)=3 THEN DATEDIFF(DAY, -5, @DateFin)/7-DATEDIFF(DAY, -4, @DateDebut)/7
WHEN DATEPART(DW,DATECR)=4 THEN DATEDIFF(DAY, -4, @DateFin)/7-DATEDIFF(DAY, -3, @DateDebut)/7
WHEN DATEPART(DW,DATECR)=5 THEN DATEDIFF(DAY, -3, @DateFin)/7-DATEDIFF(DAY, -2, @DateDebut)/7
WHEN DATEPART(DW,DATECR)=6 THEN DATEDIFF(DAY, -2, @DateFin)/7-DATEDIFF(DAY, -1, @DateDebut)/7
WHEN DATEPART(DW,DATECR)=7 THEN DATEDIFF(DAY, -1, @DateFin)/7-DATEDIFF(DAY, 0, @DateDebut)/7 END AS NbJour |
Partager