SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by theBainster / Return Column as List of Comma Seperated Values / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 17:07:33 GMT20RE: Return Column as List of Comma Seperated Valueshttp://www.sqlservercentral.com/Forums/Topic410469-944-1.aspxA simple script to get comma seperated result. :cool:[code="sql"]declare @empids varchar(max);set @empids = '';select @empids = convert(varchar, empid) + ', ' + @empids FROM employeeselect @empids--output--, 1 , 2, 3 , 4[/code]Wed, 30 Dec 2009 06:48:44 GMTsudhanvaReturn Column as List of Comma Seperated Valueshttp://www.sqlservercentral.com/Forums/Topic410469-944-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/T-SQL+Aids/30961/">Return Column as List of Comma Seperated Values</A>[/B]Sat, 13 Oct 2007 18:44:46 GMTtheBainster