TSQL Challenge 15 - Solution by Cade Roux



-- File Name: cade_roux_tsqlchallenge_15.sql
SELECT  *
FROM    ( SELECT    Col,
                    Row,
                    CASE WHEN Row % Col = 0 THEN 'x'
                         ELSE ''
                    END AS Div
          FROM      @Cols
                    CROSS JOIN @Rows
        ) AS p PIVOT ( MAX(Div) FOR Col IN ( [1], [2], [3], [4], [5], [6], [7], [8], [9] ) ) AS pvt
ORDER BY Row;