query result tab names
Posted: Mon 13 Dec 2021 12:51
I am running a procedure that executes lots of other procedures and dumps the output into temp tables that have a TABLE type. A trimmed down example:
I end up with multiple result tabs, however only one tab picks up a temp table name. All others are Query 1, Query 2, etc:
There are no difference (aside the query logic) within the procs, the way the TABLE types are defined, the way the variables are declared, the way they're being ran etc.
Is there a reason it's only picking up one temp table name or have is it a bug?
Code: Select all
DECLARE @temp_results_1 dbo.results_1
DECLARE @temp_results_2 dbo.results_2
INSERT INTO @temp_results_1 EXEC [dbo].[process_results_1]
INSERT INTO @temp_results_2 EXEC [dbo].[process_results_2]
SELECT * FROM @temp_results_1
SELECT * FROM @ttemp_results_2There are no difference (aside the query logic) within the procs, the way the TABLE types are defined, the way the variables are declared, the way they're being ran etc.
Is there a reason it's only picking up one temp table name or have is it a bug?