• + 0 comments

    WITH pattern AS ( SELECT 1 AS N UNION ALL SELECT N + 1 FROM pattern WHERE N < 20 ) SELECT REPLICATE(' *',N) FROM pattern OPTION (MAXRECURSION 0)