请 newly_ignorant(不学无术) 兄进来领分

Question

让我早上很爽啊，多谢
赫赫

Answer 1

是不是这样？：
select wname as '项目名称'
,sum(case  when  
 datepart(weekday,tdate)<=5 
and datepart(weekday,'2002-8-22')+datediff(weekday,'2002-8-22',tdate)<=5
and thour>0 then thour else 0 end) as '第一周' 
,sum(case  when  
 datepart(weekday,tdate)<=5 
and datepart(weekday,'2002-8-22')+datediff(weekday,'2002-8-22',tdate)>=8
and datepart(weekday,'2002-8-22')+datediff(weekday,'2002-8-22',tdate)<=12
and thour>0 then thour else 0 end) as '第二周' 
,sum(case  when  
 datepart(weekday,tdate)<=5 
and datepart(weekday,'2002-8-22')+datediff(weekday,'2002-8-22',tdate)>=15
and datepart(weekday,'2002-8-22')+datediff(weekday,'2002-8-22',tdate)<=19
and thour>0 then thour else 0 end) as '第三周' 
from worktime a,worker b where  a.twid=*b.wid and a.tdate>='2002-8-22' and a.tdate<='2002-9-10'
group by b.wid,wname嘿嘿