Relative Content

Tag Archive for sqlsql-serverstored-procedurestemp-tables

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: