Many times I need to write something like the following when dealing with SQL Server.
create table #table_name
(
column1 int,
column2 varchar(200)
...
)
insert into #table_name
execute some_stored_procedure;
But create a table which has the exact syntax as the result of a stored procedure is a tedious task. For example, the result of sp_helppublication has 48 columns! I want to know whether there is any easy way to do this.
Thanks.
Best Answer
If the procedure just returns one result set and the ad hoc distributed queries option is enabled.
Or you can set up a loopback linked server and use that instead.