DECLARE @curDay varchar(3) BEGIN /* Vérifie que datefirst est bien à 1 (lundi) */ SET DATEFIRST 1 SELECT @curDay = CASE DATEPART(weekday, GETDATE()) WHEN 1 THEN 'LUN' WHEN 2 THEN 'MAR' WHEN 3 THEN 'MER' WHEN 4 THEN 'JEU' WHEN 5 THEN 'VEN' WHEN 6 THEN 'SAM' WHEN 7 THEN 'DIM' END SELECT '@curDay' = @curDay END