create table #temp (data varchar(32))

declare @sql varchar(512)

insert #temp 
select 'a'
union all
select 'b'
union all
select 'c'
union all
select 'd'
union all
select 'e'
union all
select 'e'
union all
select 'f'

select @sql = ''

select @sql = @sql + data from #temp

select @sql

drop table #temp

SELECT STUFF(( SELECT ''+A.data FROM (SELECT DISTINCT TOP 100 PERCENT data FROM #temp ORDER BY data) A
FOR XML PATH ('')),1,1,'')

SELECT STUFF(( SELECT ''+A.data FROM (SELECT DISTINCT TOP 100 PERCENT data FROM #temp ORDER BY data) A
FOR XML PATH ('')),1,1,'')

SELECT TOP 1 (
    SELECT DISTINCT data + ''
    FROM #temp
    FOR XML PATH(''))
FROM #temp