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
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