create table aaa
(
col nvarchar(10)
)
insert into aaa
select 1
union
select 2
union
select 3
declare @sql varchar(8000)
set @sql=’select ‘
select @sql=@sql+’max(case col when ”’+ col +”’ then col end) + ”,” + ‘
from (select distinct col from aaa) a
set @sql=left(@sql,len(@sql)-1)
set @sql=@sql+’ from aaa’
–print @sql
exec(@sql)
drop table aaa