I need a very simple piece of code to populate a single
field in a table .I believe a loop could be used but not sure.

example:
id integer

1
2
3
4
5
6
thanks
BJ

insert into table1
with temp(i) as
(
values(1)
union all
select i+1 from temp where i < 100
)
select * from temp