ms sql 行转列 实现表中统计与小计的

select 地区,count(TaskInfo.编号),sum(余额),
sum(CASE TaskInfo.客户 when '标致' then 1 else 0 end) as 交行数,
SUM(CASE TaskInfo.客户 when '标致' then 余额 else 0 end) as 交行额
from TaskInfo inner join TaskStatus on TaskInfo.编号=TaskStatus.编号
where TaskInfo.time1<'2012-5-30' and TaskStatus.time2>'2012-5-30'
group by 地区