감사합니다.

-- 임시테이블 생성

select top 400
     IDENTITY(int, 1, 1) no
into #temp_no
from zipcode  --> 1년 보다 큰테이블 아무거나.

-- 삽입

insert into Calendar
select convert(char(4), new_date, 112)          yyyy
      ,right(convert(char(6), new_date, 112),2) mm
      ,right(convert(char(8), new_date, 112),2) dd
      ,case when datepart(dw, new_date) in (1, 7)
               then '0'
               else '1'
       end                                      flag
from (
     select cast('20041201' as datetime) + no - 1 new_date
     from #temp_no a
     where cast('20041201' as datetime) + no - 1 <= cast('20051231' as datetime)
     ) a

-- 임시테이블 삭제

drop table #temp_no

-- 임시테이블을 만들기 힘들때

-- 기존테이블을 이용하여 만드는 법

select convert(char(4), new_date, 112)          yyyy
      ,right(convert(char(6), new_date, 112),2) mm
      ,right(convert(char(8), new_date, 112),2) dd
      ,case when datepart(dw, new_date) in (1, 7)
               then '0'
               else '1'
       end                                      flag
from (
     select cast('20041201' as datetime) + no - 1 new_date
     from (
          select top 400
                  (select count(*)
                   from temp_no b
                   where a.unique_col >= b.unique_col) no
          from tab1 a  --> row수가 400보다 크고 유니크한 컬럼을 가진 테이블
          ) a
     where cast('20041201' as datetime) + no - 1 <= cast('20051231' as datetime)
     ) a