Database Challenges

Here is the data used for the Basic Testing of TSQL Challenge #15

DECLARE @Cols TABLE(Col INT);

INSERT INTO @Cols VALUES (1);
INSERT INTO @Cols VALUES (2);
INSERT INTO @Cols VALUES (3);
INSERT INTO @Cols VALUES (4);
INSERT INTO @Cols VALUES (5);
INSERT INTO @Cols VALUES (6);
INSERT INTO @Cols VALUES (7);
INSERT INTO @Cols VALUES (8);
INSERT INTO @Cols VALUES (9);

/*
Col
-----------
1
2
3
4
5
6
7
8
9
*/

DECLARE @Rows TABLE(Row INT);

INSERT INTO @Rows VALUES (100);
INSERT INTO @Rows VALUES (104);
INSERT INTO @Rows VALUES (101);
INSERT INTO @Rows VALUES (99);
INSERT INTO @Rows VALUES (77);
INSERT INTO @Rows VALUES (20);
INSERT INTO @Rows VALUES (10);

/*
Row
-----------
100
104
101
99
77
20
10
*/

Here is the expected output based on the above sample data

Row         1    2    3    4    5    6    7    8    9
----------- ---- ---- ---- ---- ---- ---- ---- ---- ----
10          x    x              x                   
20          x    x         x    x                   
77          x                             x         
99          x         x                             x
100         x    x         x    x                   
101         x                                       
104         x    x         x                   x    

Note that the number of columns in the output and the order of columns in the output should match with the sample results given above.