A similar kind of question was asked before.
If this is your table:
No Name
1 aaa
1 bbb
2 ccc
1 ddd
3 eee
2 fff
Here goes the query:
SELECT No,
SUBSTRING(
(Select (',' + Name)
from Temp_Table t2
where t1.No=t2.No
order by
No,
Name
FOR xml path( '' ) ),3,1000)
FROM Temp_Table t1
group by No