merge rows data in tsql

Question

I have a table with one column that include this data

Data
'a'
'b'
'c'
'd'
'e'
'f'

How can I get combine Data column data in one varchar with cte?

result : 'abcdef'

Answer 1

You could quite simply do it using

SELECT '' + [Data] 
FROM Table1
FOR XML PATH ('') 

SQL Fiddle DEMO