数据查询转置

以Nothwind DB为测试对象：
Declare @Sql varchar(8000)
Select @Sql='Select ShipName'
Select @Sql=@Sql+',Case when CustomerID='''+CustomerID+''' then EmployeeID else 0 end ['+CustomerID+']'
From (Select Distinct top 10 CustomerID From Orders) A

--Print @Sql

Select @Sql=@Sql+' From Orders'

Exec(@Sql)