SQL Server PIVOT http://msdn.microsoft.com/en-us/library/ms177410%28v=sql.105%29.aspx [ ^ ]命令可能对你。

尝试 http： //blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/ [ ^ ]。



如果你搜索 PIVOT ，你可以找到许多其他有用的资源。

SQL Server PIVOThttp://msdn.microsoft.com/en-us/library/ms177410%28v=sql.105%29.aspx[^] command might be useful to you.
Try http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/[^] as well.

There are a number of other useful resources that you can locate if you do a search for PIVOT.