Is it possible to create a temp table from a stored procedure result set without having to specify column datatypes? If not, is it possible to create a physical table at least from the SP? The reason I am asking is because I have an SP that returns too many columns for me to declare in a create table command.
Is there something like
create table from
where columns do not need to specified and sql automaticly determines column attributes??
I am running SQL server 2008