create Table Inv (InvID   int,InvDate datetime)

create Table InvDetail(InvID int,Invo int)

insert Inv

select 1,'2007-01-01' union all

select 2,'2007-01-02' union all

select 3,'2007-02-01'

insert InvDetail

select 1,10 union all

select 1,15 union all

select 2,15 union all

select 3,7

----------------------------------------------------------------------

select datepart(year,InvDate),

       sum(case datepart(m,InvDate) when 1 then Invo else 0 end) Jan,

       sum(case datepart(m,InvDate) when 2 then Invo else 0 end) Feb,

       sum(case datepart(m,InvDate) when 3 then Invo else 0 end) Mar,

       sum(case datepart(m,InvDate) when 4 then Invo else 0 end) Apr,

       sum(case datepart(m,InvDate) when 5 then Invo else 0 end) May,

       sum(case datepart(m,InvDate) when 6 then Invo else 0 end) Jun,

       sum(case datepart(m,InvDate) when 7 then Invo else 0 end) Jul,

       sum(case datepart(m,InvDate) when 8 then Invo else 0 end) Aug,

       sum(case datepart(m,InvDate) when 9 then Invo else 0 end) Sep,

       sum(case datepart(m,InvDate) when 10 then Invo else 0 end) Oct,

       sum(case datepart(m,InvDate) when 11 then Invo else 0 end) Nev,

       sum(case datepart(m,InvDate) when 12 then Invo else 0 end) Dec

  from Inv a join InvDetail b on a.InvID = b.InvID

group by datepart(year,InvDate)

/*

            Jan  Feb  Mar  Apr  May  Jun  Jul  Aug  Sep  Oct  Nev  Dec

----------- ----------- ----------- ----------- ----------- -----------

2007        40   7    0    0    0    0    0    0    0    0    0    0

(1개 행 적용됨)

*/

최석준님,

넘 감사합니다.

덕분에 도움이 많이 됬습니다.

추운데 감기 조심하시고 행복하세요...^^