Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

changing multiple rows into a csv string

Status
Not open for further replies.

JulsY

Programmer
Jan 22, 2002
24
US
Hi,

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

I need a stored procedure that will give me output like this:
PersonID Degree
55 MD, Phd, RN
60 MD, Phd

I am having a hard time getting this to work,

has anyone tried doing this before????

Thanks,
Juls
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top