Perhaps there’s a point to this, but not for me today – but maybe in future or for you today?
create table #t (a int)
create table #A (a int, b int)
create table #B (a int, b int, C int)
create table #C (a int, b int, c int, D int)
create table #D (a int, b int, c int, D int, e int)
create table #E (a int, b int,c int,d int,e int,f int)
insert into #t
select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9 union all select 10
— 100
insert into #A
select t.a,t2.a
from #t t cross join #t t2
–10000
insert into #C
select t.a,t.a,t2.a,t2.a from #A t cross join #A t2
— 1000000
insert into #E
select t.a,t.a,t2.a ,t2.a ,t2.a ,t2.a from #A t cross join #C t2
/*– clean up
drop table #t
drop table #A
drop table #B
drop table #C
drop table #D
drop table #E
*/