T SQL - Select contents of a column into a comma separated string

Post date: Aug 27, 2009 8:18:26 AM

CREATE Function GetThatTableAsString (@ID INT)

RETURNS varchar(1000)

AS

BEGIN

DECLARE @result varchar(1000)

SET @result = ''

Select @result = @result + RTRIM(ap.value) + ', '

FROM dbo.table ap

WHERE ap.id = @ID

IF @result <> '' SET @result = LEFT(@result , LEN(@result) - 1)

RETURN (@result)

END

GO