I have table TestTable

ID Name
-------
1  A
1  B
1  C 
2  D 
2  E
3  F

I want to write a query in SQL Server 2008 which will return 

ID Name
----------    
1   A,B,C
2   D,E
3   F

Please someone help me to write this query.

sql sql-server sql-server-2008 t-sql
Edit
Report