TSQL Beginners Challenge 21 - Create SQL Server version of the ORACLE

This challenge deals with String aggregation. On occasion it is necessary to aggregate data from a number of rows into a single row, giving a list of data associated with a specific value. Oracle has an inbuilt function "WM_CONCAT"...