Database Challenges

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