62,244
社区成员




create table table1(zsid int,name varchar(50))
insert into table1 select 1 ,'a'
insert into table1 select 1 ,'b'
insert into table1 select 1 ,'c'
insert into table1 select 1 ,'d'
insert into table1 select 1 ,'e'
insert into table1 select 1 ,'f'
declare @sql varchar(8000)
select @sql=isnull(@sql+',','')+'max(case when name='''+name+''' then name end) as ['+name+']'
from table1
exec('select zsid,'+@sql+' from table1 group by zsid')