• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 392
  • Last Modified:

Multiple Values in SQL table returned in single column separated by commas

Hi Experts,

I have a SQL Server table of short (nvarchar 75) answers filed using a code to group them by. I'm wanting to run a query that will return all answers given for a specific code separated by a comma.

For example:
100    Apple
100    Orange
100    Pear
200    Grape
200    Tangerine

Query returns for group 100:
Apple, Orange, Pear

I've used FOR XML PATH in the past but was hoping to find a different approach. Thanks,

JackW9653
0
JackW9653
Asked:
JackW9653
  • 2
1 Solution
 
Rajkumar GsSoftware EngineerCommented:
Hi
Using COALESCE . Refer this example
stackoverflow.com/questions/655197/converting-rows-into-columns-in-t-sql-sql-server-2005

Raj
0
 
JackW9653Author Commented:
Hi Raj,

Thanks for your reply. I used COALESCE and was getting extra characters between text and comma, then I added a RTRIM statement and the world was right again.

JackW9653
0
 
Rajkumar GsSoftware EngineerCommented:
your are welcome
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now