Converting multiple rows into a single comma separated row

Create Table #Names (name varchar(10))

Insert Into #Names(name) values ('varun')

Insert Into #Names(name) values ('vinod')

Insert Into #Names(name) values ('manognya')

Insert Into #Names(name) values ('aradhana')

Insert Into #Names(name) values ('manoj')

SELECT * FROM #Names

SELECT STUFF((SELECT   ', '+  name as [text()] from #Names  FOR  XML PATH('')),1,2,'')

DROP Table #Names