query result tab names

[zimmertyzim]

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:

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_2

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?

[alexa]

We are planning to change this in one of the next product versions.