select * from (
select type,count(1) count, statdate from lcm_application where statdate like '2011%' group by statdate,type
) a pivot ( sum(count) for type in ([环境申请单],[设备申请单]) ) as b
select type,count(1) count, statdate from lcm_application where statdate like '2011%' group by statdate,type
) a pivot ( sum(count) for type in ([环境申请单],[设备申请单]) ) as b