declare @fest table (dt int);
insert into @fest (dt)
values (0101), (0102), (0501);

declare @pre_fest table (dt int);
insert into @pre_fest (dt)
values (1231), (0430);


;with nums as
(
select v1.n*8*8*8*8 + v2.n*8*8*8 + v3.n*8*8 + v4.n*8 + v5.n as n
from (values (0),(1),(2),(3),(4),(5),(6),(7))v1(n),
     (values (0),(1),(2),(3),(4),(5),(6),(7))v2(n),
     (values (0),(1),(2),(3),(4),(5),(6),(7))v3(n),
     (values (0),(1),(2),(3),(4),(5),(6),(7))v4(n),
     (values (0),(1),(2),(3),(4),(5),(6),(7))v5(n)
where v1.n*8*8*8*8 + v2.n*8*8*8 + v3.n*8*8 + v4.n*8 + v5.n <= DATEDIFF(DAY, '20160101', '20901231')
)

select 365 + n as CalendarID,
       DATEADD(DAY, n, '20160101') CalendarDate,
       
       case
          when f.dt is not null then 22
          when p.dt is not null then 23
          when DATEPART(DW, DATEADD(DAY, n, '20160101')) in (1, 7) then 21
          else 20
       end as DayTypeID,
       
       case
          when f.dt is not null then 0
          when p.dt is not null then 7
          when DATEPART(DW, DATEADD(DAY, n, '20160101')) in (1, 7) then 0
          else 8
       end as Hours
       
from nums n left join @fest f
        on month(DATEADD(DAY, n.n, '20160101')) * 100 + day(DATEADD(DAY, n.n, '20160101')) = f.dt
            left join @pre_fest p
        on month(DATEADD(DAY, n.n, '20160101')) * 100 + day(DATEADD(DAY, n.n, '20160101')) = p.dt
order by 1  

declare @i datetime

declare @i datetime
set @i='20160101'
while @i<='20160110'
begin
print @i
set @i=@i+1
end
-------------------
Jan  1 2016 12:00AM
Jan  2 2016 12:00AM
Jan  3 2016 12:00AM
Jan  4 2016 12:00AM
Jan  5 2016 12:00AM
Jan  6 2016 12:00AM
Jan  7 2016 12:00AM
Jan  8 2016 12:00AM
Jan  9 2016 12:00AM
Jan 10 2016 12:00AM

declare @Calendar table ([CalendarDate] datetime,[DayTypeID] int,[Hours] money)

declare @i datetime
set @i='20160101'
while @i<='20901231'
begin
INSERT INTO @Calendar([CalendarDate],[DayTypeID],[Hours])
select @i,20,8.000
set @i=@i+1
end

select COUNT(*) as cnt, 
       MIN(CalendarDate) as min_dt, 
       MAX(CalendarDate) as max_dt
from @Calendar
--------------------
cnt	min_dt	max_dt
27394	2016-01-01 00:00:00.000	2090-12-31 00:00:00.000