Thanks for your help, both of you, I have tried both methods, but eventually just used the following (abbreviated) stored procedure, which went through all the selects and inserted them into a table. It went as follows.
BEGIN
Insert Into table item1 , item2, item3
select ----
insert into table...