Temporary Result Set In Sql Server. Also you cannot use a table variable as the target of an INSERT. This is derived from a simple query and defined within the execution scope of a single SELECT INSERT UPDATE DELETE or MERGE statement.
Copying a SQL Server Stored Procedures Results Set to a Local Temp Table You can copy the results set from a stored procedure to a local temp table in a three-step process. SQL Server QA from the SQL Server Central community. We can use this temp table to store the result set data and manipulate the data from the temp table.
For example the following two commands work and return the same results.
Having stored procedures returning result sets can become a problem when you want to have control of the name and data type of the columns being returned. What tech is like in Rest of World. Create table tempTable Tem. Is there a way to return just one result set Yes but not in pure T-SQL.