Print 1 to 10 Table using SQL Query

;WITH CTE AS

(

SELECT 0 TableOf1, 0 TableOf2,

0 TableOf3,0 TableOf4,0 TableOf5,

0 TableOf6,0 TableOf7,0 TableOf8,

0 TableOf9,0 TableOf10

UNION ALL

SELECT TableOf1 + 1, TableOf2 + 2,

TableOf3 + 3, TableOf4 + 4, TableOf5 + 5,

TableOf6 + 6, TableOf7 + 7, TableOf8 + 8,

TableOf9 + 9, TableOf10 + 10

FROM CTE WHERE TableOf1 < 10

)

SELECT * FROM CTE WHERE TableOf1 <> 0

TableOf1	TableOf2	TableOf3	TableOf4	TableOf5	TableOf6	TableOf7	TableOf8	TableOf9	TableOf10
1	2	3	4	5	6	7	8	9	10
2	4	6	8	10	12	14	16	18	20
3	6	9	12	15	18	21	24	27	30
4	8	12	16	20	24	28	32	36	40
5	10	15	20	25	30	35	40	45	50
6	12	18	24	30	36	42	48	54	60
7	14	21	28	35	42	49	56	63	70
8	16	24	32	40	48	56	64	72	80
9	18	27	36	45	54	63	72	81	90
10	20	30	40	50	60	70	80	90	100