Comma Separated Result

Question

Post reply

Comma Separated Result

mbrady5

SSCrazy

Points: 2835
More actions
April 21, 2016 at 11:19 am

#306660

Hi. Looking to put my results of this query all in one field comma separated. Any thoughts or help would be awesome! Thanks
Using 2000 and 2008R2.
SELECT vi.voucher
FROM vch_item vi
WHERE vi.po_num '446549'

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

This article should help you:

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

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 2

Alternatively, in SSMS select the "output to text" option, then go to the query options for output to text and choose to use comma-delimited output.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/