Return Column as List of Comma Seperated Values

• theBainster

  Old Hand

  Points: 343

  More actions

  October 13, 2007 at 6:44 pm

  #180282

  Comments posted to this topic are about the item 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