• + 0 comments

    MS SQL SERVER SOLUTION:

    DECLARE @N INTEGER; SET @N = 1;

    with Rec_CTE as (

    select replicate('* ',@N) as R, @N as RW
    UNION ALL
    select replicate('* ',(RW+1)), RW+1 
    from Rec_CTE
    where RW<20
    

    ) select R from Rec_CTE;