62,046
社区成员
发帖
与我相关
我的任务
分享
;WITH
b AS(
select * from customer --换成你要的查询
)
declare @Sql nvarchar (4000)
set @Sql = 'select ccuscode,ccusname'
select @Sql = @Sql + ' ,case ccusname when ''' + ccusname + ''' then pubufts end [' + ccusname + ']'
from (select distinct top 50 CCusName from b) a
set @Sql = @Sql + ' from b '
print @Sql
print len(@Sql)
exec (@Sql)