CREATE TABLE ferie(ferie char(5) not null)
alter table ferie add constraint PK_FERIE primary key (ferie)

INSERT INTO ferie VALUES ('01/01')
INSERT INTO ferie VALUES ('01/05')
INSERT INTO ferie VALUES ('01/11')
INSERT INTO ferie VALUES ('08/05')
INSERT INTO ferie VALUES ('11/11')
INSERT INTO ferie VALUES ('14/07')
INSERT INTO ferie VALUES ('15/08')
INSERT INTO ferie VALUES ('25/12')

CREATE PROCEDURE  jours_paques @annee INTEGER, @paques DATETIME OUTPUT, @lundi_paques DATETIME OUTPUT, @ascension DATETIME OUTPUT, @pentecote DATETIME OUTPUT, @lundi_pentecote DATETIME OUTPUT AS    
BEGIN    
DECLARE @date DATETIME, @a INTEGER , @b INTEGER , @c INTEGER , @d INTEGER , @e INTEGER , @f INTEGER , @p INTEGER    
    
SELECT @a = @annee - 1900    
SELECT @b = @annee%19    
SELECT @c = CEILING(( 7*@b + 1 ) / 19)    
SELECT @d = ( 11*@b + 4 - @c )%29    
SELECT @e = CEILING( @a / 4 )    
SELECT @f = ( @a + @e + 31 - @d )%7    
SELECT @p = 25 - @d - @f     
    
SELECT @date = convert(datetime,'31/03' + '/' +convert(char(4),@annee),103)    
    
SELECT @paques = dateadd(day, @p, @date)    
SELECT @lundi_paques = dateadd(day, 1, @paques)    
    
SELECT @ascension = dateadd(day, 39, @paques)    
    
SELECT @pentecote = dateadd(day, 49, @paques)    
SELECT @lundi_pentecote = dateadd(day, 1, @pentecote )    
END

CREATE PROCEDURE  jours_feries @date DATETIME, @retour INTEGER OUTPUT AS    
BEGIN    
DECLARE @ferie VARCHAR(5), @ferme DATETIME, @annee INTEGER, @jour VARCHAR(5),    
         @paques DATETIME, @lundi_paques DATETIME, @ascension DATETIME, @pentecote DATETIME, @lundi_pentecote DATETIME    
    
SELECT @jour = SUBSTRING(CONVERT(CHAR(12),@date,103),1,5)    
SELECT @annee = CONVERT(INTEGER,SUBSTRING(CONVERT(CHAR(12),@date,103),7,4))    
    
SELECT @ferie = ferie     
FROM ferie    
WHERE ferie = @jour    
    
IF @jour = @ferie
BEGIN    
    SELECT @retour = 1    
END    
ELSE    
BEGIN    
    EXECUTE jours_paques @annee,     
        @paques OUTPUT, @lundi_paques OUTPUT,    
        @ascension OUTPUT,    
        @pentecote OUTPUT, @lundi_pentecote OUTPUT    
        
    IF @date = @paques OR @date = @lundi_paques OR @date = @ascension OR @date = @pentecote    
    BEGIN    
        SELECT @retour = 1    
    END    
    ELSE    
    BEGIN   
     IF @annee < 2004  and @date = @lundi_pentecote   
     BEGIN   
        SELECT @retour = 1   
     END   
     ELSE   
     BEGIN   
        SELECT @retour = 0   
     END   
    END    
END    
END

CREATE PROCEDURE  jour_ouvre @date DATETIME, @retour_ouvre INTEGER OUTPUT AS   
BEGIN   
DECLARE @num_jour INTEGER, @retour_ferie INTEGER   
/* Numéro du jour dans la semaine (1 à 7)*/
SELECT @num_jour = DATEPART(dw,@date)

/* Le jour 1 n'est pas Lundi */
IF @num_jour >= 2 AND @num_jour <= 6   
BEGIN   
  EXECUTE jours_feries @date, @retour_ferie OUTPUT   
   
    IF @retour_ferie = 0   
    BEGIN   
        SELECT @retour_ouvre = 1   
    END   
    ELSE   
    BEGIN   
        SELECT @retour_ouvre = 0   
    END   
END   
ELSE   
BEGIN    
    SELECT @retour_ouvre = 0   
END   
END

CREATE PROCEDURE  nb_jour_ouvre @date_deb DATETIME, @date_fin DATETIME, @nbj_ouvre INTEGER OUTPUT AS   
BEGIN   
DECLARE @date DATETIME, @retour_ouvre INTEGER   
   
SELECT @date = @date_deb   
SELECT @nbj_ouvre = 0   
   
WHILE ( @date <= @date_fin )           
BEGIN   
    EXECUTE jour_ouvre @date, @retour_ouvre OUTPUT   
   
    IF @retour_ouvre = 1   
    BEGIN   
        SELECT @nbj_ouvre = @nbj_ouvre + 1   
    END   
       
    SELECT @date = DATEADD(day, 1, @date)    
END   
END