TSQL Challenge 15

TSQL Challenge 15 - matching data between rows and columns

This challenge is derived from a realistic reporting scenario that requires the transformation of rows into columns. This is commonly known as a matrix, pivot, or crosstab query. This challenge involves two primary tables @Row and @Cols. The objective will be to create a matrix result set. See TSQL Challenge #15 for a detailed description of this challenge.

The current status of this challenge is Closed, however, if you have a better solution, we will be glad to review it and publish it. To submit a solution, see the Submission Guidelines