Display results as vertical string? Use PIVOT?

• RedBirdOBX

  SSCommitted

  Points: 1836

  More actions

  June 9, 2014 at 8:06 am

  #396884

  Hello all -

  This is probably very simple but the solution evades me. I have a single column returned from a select statement. How can I have this returned as a vertical string? I looked into using PIVOT but my scenario seems too simple to use Pivot. I'm not requiring any aggregate functions or anything.

  So, I want to turn this:

  SELECT CountyNames + ',' FROM Counties

  ---------------------

  County1 ,

  County2 ,

  County3 ,

  ..etc

  TO:

  County1, County2, County3...etc

  Please note that the list of rows is unknown. Could be 1. Could be 50.

  Thanks in advance!!

• DavidOwen983

  SSC Journeyman

  Points: 77

  More actions

  June 9, 2014 at 2:00 pm

  #1720205

  declare @myCSV varchar(1000)

  set @myCSV=''

  select @myCSV=@myCSV+','+ name from sys.databases

  select substring(@myCSV, 2, len(@myCSV)-1) as myCSV

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  June 9, 2014 at 2:08 pm

  #1720206

  If I understand correctly, this article explains what you need:

  http://www.sqlservercentral.com/articles/comma+separated+list/71700/

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2