New Tables, Stored Procedures and UNION clauses

[DinosBarandGrill]

Hi forum!

I have a working stored procedure that concatinates records from a number of tables via UNION.

I now need to create a new table (through code) using the results of this SP and have discovered that using &quot;select * into <newtable> from <sourcerecordset>&quot; does not work if the <sourcerecordset> is a storedprocedure but it does work if the <sourcerecordset> is a table.

I've searched everywhere (I think) and I'm stuck.

Thanks in anticipation...

Dino

 

[swampBoogie]

insert into t exec p

 

[DinosBarandGrill]

Thank you SwampBoogie. I have tried this already but suspect that the table needs to have been created first in order for &quot;insert into t exec p&quot; to work???