• + 0 comments

    with starpattern as (select 1 as num union all select num + 1 from starpattern where num<20 ) select replicate('* ', num)as stars from starpattern option(maxrecursion 0);