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
No comments:
Post a Comment