Database Challenges

-- File Name: kevin_suchlicki_tsqlchallenge_15.sql

SELECT	Row, [1], [2], [3], [4], [5], [6], [7], [8], [9]
FROM	(select	r.row, c.col, case when Row % Col = 0 then 'X' else '' end val
		from	@Rows r
				Cross Join @Cols c) As PivotSource
PIVOT
		(Min (val) for col in ([1],[2],[3],[4],[5],[6],[7],[8],[9]) 
) As p1
ORDER BY row;

Did you find something incorrect/wrong with this solution? Take a few seconds to Report It.

Did you understand how this solution work? If you find it difficult to understand, you can Request an Explanation or you can Write an explanation to help others better understand this solution.