select 缴费人编号=[user]
,[1月_应交]=sum(case [month] when 1 then consume else 0 end)
,[1月_实交]=sum(case [month] when 1 then charge else 0 end)
,[2月_应交]=sum(case [month] when 2 then consume else 0 end)
,[2月_实交]=sum(case [month] when 2 then charge else 0 end)
,[3月_应交]=sum(case [month] when 3 then consume else 0 end)
,[3月_实交]=sum(case [month] when 3 then charge else 0 end)
,[4月_应交]=sum(case [month] when 4 then consume else 0 end)
,[4月_实交]=sum(case [month] when 4 then charge else 0 end)
,[5月_应交]=sum(case [month] when 5 then consume else 0 end)
,[5月_实交]=sum(case [month] when 5 then charge else 0 end)
,[6月_应交]=sum(case [month] when 6 then consume else 0 end)
,[6月_实交]=sum(case [month] when 6 then charge else 0 end)
,[7月_应交]=sum(case [month] when 7 then consume else 0 end)
,[7月_实交]=sum(case [month] when 7 then charge else 0 end)
,[8月_应交]=sum(case [month] when 8 then consume else 0 end)
,[8月_实交]=sum(case [month] when 8 then charge else 0 end)
,[9月_应交]=sum(case [month] when 9 then consume else 0 end)
,[9月_实交]=sum(case [month] when 9 then charge else 0 end)
,[10月_应交]=sum(case [month] when 10 then consume else 0 end)
,[10月_实交]=sum(case [month] when 10 then charge else 0 end)
,[11月_应交]=sum(case [month] when 11 then consume else 0 end)
,[11月_实交]=sum(case [month] when 11 then charge else 0 end)
,[12月_应交]=sum(case [month] when 12 then consume else 0 end)
,[12月_实交]=sum(case [month] when 12 then charge else 0 end)
from charge
group by [user]
,[1月_应交]=sum(case [month] when 1 then consume else 0 end)
,[1月_实交]=sum(case [month] when 1 then charge else 0 end)
,[2月_应交]=sum(case [month] when 2 then consume else 0 end)
,[2月_实交]=sum(case [month] when 2 then charge else 0 end)
,[3月_应交]=sum(case [month] when 3 then consume else 0 end)
,[3月_实交]=sum(case [month] when 3 then charge else 0 end)
,[4月_应交]=sum(case [month] when 4 then consume else 0 end)
,[4月_实交]=sum(case [month] when 4 then charge else 0 end)
,[5月_应交]=sum(case [month] when 5 then consume else 0 end)
,[5月_实交]=sum(case [month] when 5 then charge else 0 end)
,[6月_应交]=sum(case [month] when 6 then consume else 0 end)
,[6月_实交]=sum(case [month] when 6 then charge else 0 end)
,[7月_应交]=sum(case [month] when 7 then consume else 0 end)
,[7月_实交]=sum(case [month] when 7 then charge else 0 end)
,[8月_应交]=sum(case [month] when 8 then consume else 0 end)
,[8月_实交]=sum(case [month] when 8 then charge else 0 end)
,[9月_应交]=sum(case [month] when 9 then consume else 0 end)
,[9月_实交]=sum(case [month] when 9 then charge else 0 end)
,[10月_应交]=sum(case [month] when 10 then consume else 0 end)
,[10月_实交]=sum(case [month] when 10 then charge else 0 end)
,[11月_应交]=sum(case [month] when 11 then consume else 0 end)
,[11月_实交]=sum(case [month] when 11 then charge else 0 end)
,[12月_应交]=sum(case [month] when 12 then consume else 0 end)
,[12月_实交]=sum(case [month] when 12 then charge else 0 end)
from charge
group by [user]
解决方案 »
- 已建发布与订阅,可是数据没有同步,要手动“生成快照”数据才能同步,Help Me!TKS!
- 求一SQL语句?
- OLE DB和ODBC有什么区别?哪个更适合sql server?
- 关于一个查询语句的问题,请各位高手帮忙!!!
- 存储过程调试只能调本机上库,不能调其他服务器上库的问题
- 紧急求助:Visual Foxpro中使用Run命令和append from命令?
- nononono(null,null),dudo(dudo).............你们在哪里?你快来呀。。。。。。。。
- 请问如何-减小数据库的日志文件
- 很急,快吐血了!怎样动态建一个Sql表,要求表名有规律,高分请进!!!
- 存储过程的变量
- 给点建议
- 帮忙解释一下 master..xp_cmdshell (邹建大哥如果有空的话,请帮小弟一把)
这样的执行效率高吗?或者应该重新设计一下表的结构?
,[1月_应交]=sum(case [month] when 1 then consume else 0 end)
,[1月_实交]=sum(case [month] when 1 then charge else 0 end)
,[2月_应交]=sum(case [month] when 2 then consume else 0 end)
,[2月_实交]=sum(case [month] when 2 then charge else 0 end)
,[3月_应交]=sum(case [month] when 3 then consume else 0 end)
,[3月_实交]=sum(case [month] when 3 then charge else 0 end)
,[4月_应交]=sum(case [month] when 4 then consume else 0 end)
,[4月_实交]=sum(case [month] when 4 then charge else 0 end)
,[5月_应交]=sum(case [month] when 5 then consume else 0 end)
,[5月_实交]=sum(case [month] when 5 then charge else 0 end)
,[6月_应交]=sum(case [month] when 6 then consume else 0 end)
,[6月_实交]=sum(case [month] when 6 then charge else 0 end)
,[7月_应交]=sum(case [month] when 7 then consume else 0 end)
,[7月_实交]=sum(case [month] when 7 then charge else 0 end)
,[8月_应交]=sum(case [month] when 8 then consume else 0 end)
,[8月_实交]=sum(case [month] when 8 then charge else 0 end)
,[9月_应交]=sum(case [month] when 9 then consume else 0 end)
,[9月_实交]=sum(case [month] when 9 then charge else 0 end)
,[10月_应交]=sum(case [month] when 10 then consume else 0 end)
,[10月_实交]=sum(case [month] when 10 then charge else 0 end)
,[11月_应交]=sum(case [month] when 11 then consume else 0 end)
,[11月_实交]=sum(case [month] when 11 then charge else 0 end)
,[12月_应交]=sum(case [month] when 12 then consume else 0 end)
,[12月_实交]=sum(case [month] when 12 then charge else 0 end)
,[12个月_应交]=sum(consume)
,[12个月_实交]=sum(charge)
from charge
group by [user]
union all
select '',
,[1月_应交]=sum(case [month] when 1 then consume else 0 end)
,[1月_实交]=sum(case [month] when 1 then charge else 0 end)
,[2月_应交]=sum(case [month] when 2 then consume else 0 end)
,[2月_实交]=sum(case [month] when 2 then charge else 0 end)
,[3月_应交]=sum(case [month] when 3 then consume else 0 end)
,[3月_实交]=sum(case [month] when 3 then charge else 0 end)
,[4月_应交]=sum(case [month] when 4 then consume else 0 end)
,[4月_实交]=sum(case [month] when 4 then charge else 0 end)
,[5月_应交]=sum(case [month] when 5 then consume else 0 end)
,[5月_实交]=sum(case [month] when 5 then charge else 0 end)
,[6月_应交]=sum(case [month] when 6 then consume else 0 end)
,[6月_实交]=sum(case [month] when 6 then charge else 0 end)
,[7月_应交]=sum(case [month] when 7 then consume else 0 end)
,[7月_实交]=sum(case [month] when 7 then charge else 0 end)
,[8月_应交]=sum(case [month] when 8 then consume else 0 end)
,[8月_实交]=sum(case [month] when 8 then charge else 0 end)
,[9月_应交]=sum(case [month] when 9 then consume else 0 end)
,[9月_实交]=sum(case [month] when 9 then charge else 0 end)
,[10月_应交]=sum(case [month] when 10 then consume else 0 end)
,[10月_实交]=sum(case [month] when 10 then charge else 0 end)
,[11月_应交]=sum(case [month] when 11 then consume else 0 end)
,[11月_实交]=sum(case [month] when 11 then charge else 0 end)
,[12月_应交]=sum(case [month] when 12 then consume else 0 end)
,[12月_实交]=sum(case [month] when 12 then charge else 0 end)
,[12个月_应交]=sum(consume)
,[12个月_实交]=sum(charge)
from charge
http://community.csdn.net/Expert/topic/3131/3131750.xml?temp=.5504114
谢谢