Home Forums Article Discussions Article Discussions by Author Discuss content posted by theBainster Return Column as List of Comma Seperated Values RE: Return Column as List of Comma Seperated Values
sudhanva
Ten Centuries
Points: 1343
More actions
December 30, 2009 at 6:48 am
#1097404
A simple script to get comma seperated result. 😎
declare @empids varchar(max);
set @empids = '';
select @empids = convert(varchar, empid) + ', ' + @empids
FROM employee
select @empids
--output
--, 1 , 2, 3 , 4