[a]
b=insert into  wkrslt2(dptname,emplyid,emplyname,正常天,異常天,休息天,休日加班天,出差天,請(qǐng)假天,遲到次,遲到分,早退次,早退分,實(shí)際工時(shí),標(biāo)準(zhǔn)工時(shí),在崗工時(shí),平時(shí)加班,休日加班,請(qǐng)假工時(shí)) select dptname as 部門,emplyid as 工號(hào),emplyname as 姓名,sum(case when wktmrslt_flag=7 then 1 else 0 end) as 正常天,sum(case when wktmrslt_flag=1 then 1 else 0 end) as 異常天,sum(case when wktmrslt_flag=4 or wktmrslt_flag=5 then 1 else 0 end) as 休息天,sum(case when wktmrslt_flag=9 then 1 else 0 end) as 休日加班天,sum(case when wktmrslt_flag=3 then 1 else 0 end) as 出差天,sum(case when wktmrslt_flag=2 then 1 else 0 end) as 請(qǐng)假天,sum(case when latertime1+latertime2>0 then  1 else 0 end) as 遲到次,sum(latertime1+latertime2) as 遲到分,sum(case when earlytime1+earlytime2>0 then  1 else 0 end) as 早退次,sum(earlytime1+earlytime2) as 早退分,sum(datwktm) as 實(shí)際工時(shí),sum(standwktm) as 標(biāo)準(zhǔn)工時(shí),sum(workwktm) as 在崗工時(shí),sum(overwktm) as 平時(shí)加班工時(shí),sum(sunwktm) as 休日加班工時(shí),sum(holidaysum) as 請(qǐng)假工時(shí)  from wktmrslt  where caldate between '2005-05-01' and '2005-05-31'  group by dptname,emplyid,emplyname