SQL查询问题，求解!
写了一个多表联合查询，得出的结果如下，
年份 月份 金额
2010116343452.2900
2011134714865.7800
2012123177526.9500
201025121401.5100
2011216997526.3300
2012224160669.4600
2010328610693.5200
2011325971268.5300
2012325628081.1200
2010428074691.0000
2011430419215.0300
2012425091458.9600
2010525869667.9900
2011520642975.2800
2012526496561.5900
2010611200870.5900
2011622167706.0000
2010727954602.5800
2011723542639.2200
2010827273035.9200
2011824329271.8200
2010923234301.1400
2011935396877.4500
20101026076753.9400
20111026727053.0500
20101124883698.6200
20111119087985.8200
20101221339280.3600
201112464040452.7700
请问如何实现下列排序效果呢？
年份1月2月3月4月5月6月7月8月9月10月11月12月
2010金额金额金额金额金额金额金额金额金额金额金额金额
2011金额金额金额金额金额金额金额金额金额金额金额金额
2012金额金额金额金额金额金额金额金额金额金额金额金额
[解决办法]
行列转换
SELECT 年份,SUM(CASE 月份 WHEN 1 THEN 金额 ELSE 0 END) AS [1月],SUM(CASE 月份 WHEN 2 THEN 金额 ELSE 0 END) AS [2月]...,SUM(CASE 月份 WHEN 12 THEN 金额 ELSE 0 END) AS [12月]FROM (--这里写你原来的查询语句) AS TGROUP BY 年份
