列转行

[解决办法]
select * from (select * from #TT) a pivot (max(NetPaid) for fromdateString in ('20120401','20120501')) b
[解决办法]
 select * from (select * from #TT) a pivot (max(NetPaid) for fromdateString in ([20120401],[20120501])) b