with t as (
select cast('20110101' as datetime) cdate, 1 Input union all
select cast('20110102' as datetime) cdate, 9 Input union all
select cast('20110103' as datetime) cdate, 3 Input union all
select cast('20110104' as datetime) cdate, 2 Input union all
select cast('20110105' as datetime) cdate, 0 Input union all
select cast('20110106' as datetime) cdate, 4 Input union all
select cast('20110107' as datetime) cdate, 5 Input union all
select cast('20110108' as datetime) cdate, 2 Input union all
select cast('20110109' as datetime) cdate, 1 Input union all
select cast('20110110' as datetime) cdate, 0 Input union all
select cast('20110111' as datetime) cdate, 1 Input union all
select cast('20110112' as datetime) cdate, 4 Input union all
select cast('20110113' as datetime) cdate, 5 Input union all
select cast('20110114' as datetime) cdate, 8 Input union all
select cast('20110115' as datetime) cdate, 4 Input union all
select cast('20110116' as datetime) cdate, 7 Input union all
select cast('20110117' as datetime) cdate, 2 Input union all
select cast('20110118' as datetime) cdate, 1 Input union all
select cast('20110119' as datetime) cdate, 6 Input union all
select cast('20110120' as datetime) cdate, 9 Input union all
select cast('20110121' as datetime) cdate, 0 Input union all
select cast('20110122' as datetime) cdate, 4 Input union all
select cast('20110123' as datetime) cdate, 6 Input union all
select cast('20110124' as datetime) cdate, 7 Input union all
select cast('20110125' as datetime) cdate, 3 Input union all
select cast('20110126' as datetime) cdate, 8 Input union all
select cast('20110127' as datetime) cdate, 9 Input union all
select cast('20110128' as datetime) cdate, 2 Input union all
select cast('20110129' as datetime) cdate, 5 Input union all
select cast('20110130' as datetime) cdate, 1 Input union all
select cast('20110131' as datetime) cdate, 8 Input
)
select isnull(cast(year(cdate) as varchar(4)) +'.'+ cast(month(cdate) as varchar(2)), 'TOTAL') '비고'
     , sum(case when datename(week, cdate) = 1 then Input end) '1주'
     , sum(case when datename(week, cdate) = 2 then Input end) '2주'
     , sum(case when datename(week, cdate) = 3 then Input end) '3주'
     , sum(case when datename(week, cdate) = 4 then Input end) '4주'
     , sum(case when datename(week, cdate) = 5 then Input end) '5주'
     , sum(case when datename(week, cdate) = 6 then Input end) '6주'
  from t
 where year(cdate)  = 2011
   and month(cdate) = 01
 group by cast(year(cdate) as varchar(4)) +'.'+ cast(month(cdate) as varchar(2)) with rollup