DECLARE @t tABLE (Name varchar(10), Hobbies varchar(15))
insert into @t
SELECT 'Michael','Shopping' union all
SELECT 'Michael','Movie' union all
SELECT 'James','Shopping' union all
SELECT 'James','Movie' union all
SELECT 'James', 'Drawing'

SELECT name, Hobbies , STUFF(( SELECT ','+Hobbies FROM @t t2 WHERE t1.name= t2.Name FOR XML PATH('')), 1,1, '') AS Hobbies1
FROM @t t1

quote:

---

Originally posted by sanjay5219

Thanks Chandu,

I have given just an example I am having around more than 10000 rows for this.

---