insert into table

[scott andreas]

Hello

I have a table that has a a nitems with varchar (8) as its definition. What I need is to use an insert into a xdoc table that will produce a number of inserts based on the data in nitems.

example: lets say nitems has a value of 10. in the xdoc table to produce new inserts statements with 10 different insert values for each of the column defined

INSERT INTO docx(item,id,path,...)
VALUES (item1,id,user/1,...),
(item2,id,user/2,...),
(item3,id,user/3,...),
(item4,id,user/4,...),
(item5,id,user/5,...),
(item6,id,user/6,...),
(item7,id,user/7,...),
(item8,id,user/8,...),
(item9,id,user/9,...),
(item10,id,user/10,...);


tried with select into and insert with select statements but just cannot figure this out


thank you in advance