Pushing Stored Procedure output into #temp table with out using openrowset

Hello,

You can use SET FMTONLY ON/OFF or you can use the new recommended way to do that: sp_describe_first_result_set/sys.dm_exec_describe_first_result_set.

And after create dynamically the #temporary table and call again the procedure.

The disadvantage is that you run twice the proc, and this work only if you have only one result set.

It should work but it's very ugly



Regards

Alex