Query to get all row values as comma separated

[indian143]

Hi All, I want to get all the values of a column as comma separated values in SQL Server. Can anybody help me writing the query for that. Thanks in advance.

Thanks & Regards, Md. Abdul Aleem NIIT technologies

[Mycroft Holmes]

Here is an example

DECLARE @String VARCHAR(1000)

SET @String = ''

SELECT @String = @String + ',' + Column1
FROM Table1

SELECT @String

Never underestimate the power of human stupidity RAH