以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)