统计当月人数

select m1=sum(m1),m2=sum(m2),m3=sum(m3),   m4=sum(m4),m5=sum( m5),m6= sum(m6),m7= sum(m7),m8=sum(m8),m9=sum(m9),m10=sum(m10),m11= sum(m11),m12=  sum(m12)from (select personcode,m1=case when  datediff(m,joindate,'2008-01-1')>=0 and datediff(m,isnull(outDate,'9999-12-12'),'2008-01-1')<=0 then 1 else 0end,m2=case when  datediff(m,joindate,'2008-02-1')>=0 and datediff(m,isnull(outDate,'9999-12-12'),'2008-02-1')<=0 then 1 else 0end, m3=case when  datediff(m,joindate,'2008-03-1')>=0 and datediff(m,isnull(outDate,'9999-12-12'),'2008-03-1')<=0 then 1 else 0end ,m4=case when  datediff(m,joindate,'2008-04-1')>=0 and datediff(m,isnull(outDate,'9999-12-12'),'2008-04-1')<=0 then 1 else 0end ,m5=case when  datediff(m,joindate,'2008-05-1')>=0 and datediff(m,isnull(outDate,'9999-12-12'),'2008-05-1')<=0 then 1 else 0end ,m6=case when  datediff(m,joindate,'2008-06-1')>=0 and datediff(m,isnull(outDate,'9999-12-12'),'2008-06-1')<=0 then 1 else 0end ,m7=case when  datediff(m,joindate,'2008-07-1')>=0 and datediff(m,isnull(outDate,'9999-12-12'),'2008-07-1')<=0 then 1 else 0end ,m8=case when  datediff(m,joindate,'2008-08-1')>=0 and datediff(m,isnull(outDate,'9999-12-12'),'2008-08-1')<=0 then 1 else 0end ,m9=case when  datediff(m,joindate,'2008-09-1')>=0 and datediff(m,isnull(outDate,'9999-12-12'),'2008-09-1')<=0 then 1 else 0end ,m10=case when  datediff(m,joindate,'2008-10-1')>=0 and datediff(m,isnull(outDate,'9999-12-12'),'2008-10-1')<=0 then 1 else 0end ,m11=case when  datediff(m,joindate,'2008-11-1')>=0 and datediff(m,isnull(outDate,'9999-12-12'),'2008-11-1')<=0 then 1 else 0end ,m12=case when  datediff(m,joindate,'2008-12-1')>=0 and datediff(m,isnull(outDate,'9999-12-12'),'2008-12-1')<=0 then 1 else 0end from  tbperson) as f