Comma Separated List from Column in SQL

  1. DECLARE @list VARCHAR(MAX)    
  2. SELECT @list = COALESCE(@list+',' , '') + columnname    
  3. FROM tablename    
  4. SELECT @list