嗨迈克尔，



你可以使用PIVOT表来获得你想要的输出。



请参考以下链接：



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



如果您对此有任何疑问或疑问，请与我们联系。



谢谢

Hi Michael,

You can use PIVOT table to get the output that you want.

Please refer below link:

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

Please let me know if you have any concern or query on this.

Thanks