Contatenate data from rows 1

[stnkyminky]

I've got a query that will return the following results

Name|Hobbies
Bob | Biking
Bob | Golfing
Bob | Baseball

Is there a way to return the following:
Bob | Biking,Golfing,Baseball ?




Scott
Programmer Analyst
<{{><

 

[JayKusch]

For sure with a dreaded "Cursor". Not sure you can achieve the desired results w/ a set based query BUT maybe on of the gurus here can come up with an example.

Thanks

J. Kusch

 

[johnherman]

see thread183-788435

Sometimes the grass is greener on the other side because there is more manure there - original.