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
|
WITH periode AS (
SELECT CONVERT(DATETIME2, '2014-12-24') AS jour
UNION ALL
SELECT DATEADD(DAY, 1, jour) FROM periode WHERE jour <= '2015-01-08'
)
select P.jour AS 'Date',
S.nom,
datepart(week,P.jour) AS 'sem_pas_iso',
datepart(iso_week, P.jour) AS 'sem_iso',
datepart(iso_week, DATEADD(day, 1, P.jour)) AS 'sem_iso_dim'
from periode AS P
INNER JOIN (
SELECT 1 AS jour, 'Lundi' AS nom
UNION
SELECT 2 AS jour, 'Mardi' AS nom
UNION
SELECT 3 AS jour, 'Mercredi' AS nom
UNION
SELECT 4 AS jour, 'Jeudi' AS nom
UNION
SELECT 5 AS jour, 'Vendredi' AS nom
UNION
SELECT 6 AS jour, 'Samedi' AS nom
UNION
SELECT 7 AS jour, 'Dimanche' AS nom
) AS S ON datepart(WEEKDAY, P.jour) = S.jour
ORDER BY P.jour |
Partager