group records bases on one column name in data set and display all the values corresponding to the column for which records are grouped in SQL
Simulating group_concat MySQL function in Microsoft SQL Server 2005?