How to Display Column Data in Comma Separated Form in SQL Server

[Prashanth Rao]

select stuff((select ','+[Column_Name] from <TableName> for xml path('')),1,1,'')

[Rabbit]

This is the correct syntax

SELECT Country,  
(STUFF((SELECT ',' + FirstName FROM Employees E2 WHERE  E1.Country = E2.Country ORDER BY FirstName FOR XML PATH(''), TYPE, ROOT).value('root[1]','nvarchar(max)'),1,1,'')) as FirstNames  
FROM Employees E1

[Prashanth Rao]

Hi Rabbit,
Actually i have written for selecting a single column value from single table..so that was correct .you have sent a replay for selecting a relationship column data ..my query is working fine in my system..sorry if i am wrong...