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