Combining data from multiple records into a single field

Question

Possible Duplicate:
Simulating group_concat MySQL function in MS SQL Server 2005?

My query looks like this:

select analyst, issuer, coveragegroup
from analystcoverage

There can be multiple analysts for a particular issuer. When this is the case, I want to concatenate their names in a single record.

I want these two records:

John Doe      Walmart      Fixed Income
Bill Jones    Walmart      Fixed Income

to be returned as:

John Doe; Bill Jones      Walmart      Fixed Income

This is a fairly commonly asked question. Have you tried searching for other similar questions? — Mark Byers, Apr 09 '12 at 14:47
See http://stackoverflow.com/questions/451415/simulating-group-concat-mysql-function-in-ms-sql-server-2005 — Michael Berkowski, Apr 09 '12 at 14:48

score 0 · Answer 1 · edited May 23 '17 at 10:34

0

One option would be to use COALESCE. I know how to use it, but I'm not sure how to tell it to only concatenate records with equal values. Here's the code to get you started:

Concatenate many rows into a single text string?

edited May 23 '17 at 10:34

Community

1
1

answered Apr 09 '12 at 14:55

Jared

878
3
11
19

Combining data from multiple records into a single field

1 Answers1