Declaring a Temporary Table inside a Stored Procedure
I’m trying to create a stored procedure in SQL Server that accepts a list of indicators, executes a dynamic query for each indicator and combines the results into a temporary table. However, I’m encountering an error when trying to declare the temporary table:
Declaring a Temporary Table inside a Stored Procedure in SQL Server
I’m trying to create a stored procedure in SQL Server that accepts a list of indicators, executes a dynamic query for each indicator and combines the results into a temporary table. However, I’m encountering an error when trying to declare the temporary table: