Getting data from multiple rows into one column

From: "bika" <aesahab@xxxxxxxxx>
Date: 2 Dec 2005 16:58:34 -0800

I have a table that has values as follows:
PersonID Degree
55 MD
55 Phd
55 RN
60 MD
60 Phd

I need a create a query that will give me output like this:

PersonID Degree
55 MD, Phd, RN
60 MD, Phd

Any ideas

.

Follow-Ups:
- Re: Getting data from multiple rows into one column
  - From: --CELKO--
- Re: Getting data from multiple rows into one column
  - From: Rich Ryan
- Re: Getting data from multiple rows into one column
  - From: gjvdkamp
- Re: Getting data from multiple rows into one column
  - From: Erland Sommarskog

Prev by Date: SP and ADO Page Property Not Working Properly
Next by Date: Re: Databases not showing up in Enterprise Manager
Previous by thread: SP and ADO Page Property Not Working Properly
Next by thread: Re: Getting data from multiple rows into one column
Index(es):
- Date
- Thread

Relevant Pages

Re: Getting data from multiple rows into one column
... So to create a query that creates repeating groups ... > PersonID Degree ... > 55 Phd ...
(comp.databases.ms-sqlserver)
Re: Getting data from multiple rows into one column
... > PersonID Degree ... > 55 Phd ... I got this example from an SQL Server developer: ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver)
Re: Getting data from multiple rows into one column
... be you can use this query: ... group by PersonId ... Gert-Jan ... Prev by Date: ...
(comp.databases.ms-sqlserver)
Sorting & Grouping report
... I don't know if this is possible but I have a report grouped on a PersonID # ... there any way to combine the grouping or redo my query to both group on ID ... Gil ... Prev by Date: ...
(microsoft.public.access.reports)
Re: An interesting problem of algebra
... Thaddeus L. Olczyk, PhD ... and *knowing* you know something. ... Prev by Date: ...
(sci.math)