select convert(varchar(6),日期字段,112), sum(case when Ewstatus='N' then 1 else 0 end)*100.0/count(*), sum(case when Ewstatus='A' then 1 else 0 end)*100.0/count(*), sum(case when Ewstatus='L' then 1 else 0 end)*100.0/count(*), sum(case when Ewstatus='W' then 1 else 0 end)*100.0/count(*) from tb_masEmployeeEmployer a inner join tb_masCustomer e on a.CustomerID=e.CustomerID where 1=1 group by convert(varchar(6),日期字段,112), order by CustomerName
sum(case when Ewstatus='N' then 1 else 0 end)*100.0/count(*),
sum(case when Ewstatus='A' then 1 else 0 end)*100.0/count(*),
sum(case when Ewstatus='L' then 1 else 0 end)*100.0/count(*),
sum(case when Ewstatus='W' then 1 else 0 end)*100.0/count(*)
from tb_masEmployeeEmployer a inner join tb_masCustomer e on a.CustomerID=e.CustomerID
where 1=1
group by convert(varchar(6),日期字段,112),
order by CustomerName