Thanks for that
. I modified the code in that link to...
Code:
declare @DelimitedString varchar(500)
Select @DelimitedString = isnull(@DelimitedString + ', ', '') + education.course
From education
select distinct name.id, @DelimitedString
from name
inner join education on name.id = education.id
...it does concatenate multiple values in one field, however it includes every value contained in the course field on every record (until it runs over 500 chars
), while I only want the courses that an individual has completed. Should there be a group by in there somewhere?