The answer you’re looking for is found in a similar SO question by Josh Burke:
-- Assume this table matches the output of your procedure
DECLARE @tmpNewValue TABLE ([Id] int, [Name] varchar(50))
INSERT INTO @tmpNewValue
EXEC [ProcedureB]
-- SELECT [Id], [Name] FROM @tmpNewValue
Related Contents:
- Function vs. Stored Procedure in SQL Server
- How can I get column names from a table in SQL Server?
- How can I list all foreign keys referencing a given table in SQL Server?
- Get top 1 row of each group
- How to select all records from one table that do not exist in another table?
- OR is not supported with CASE Statement in SQL Server
- What is the meaning of the prefix N in T-SQL statements and when should I use it?
- Select statement to find duplicates on certain fields
- How to set variable from a SQL query?
- T-SQL Cast versus Convert
- When to use Common Table Expression (CTE)
- How do I create a foreign key in SQL Server?
- How can a LEFT OUTER JOIN return more records than exist in the left table?
- Change Schema Name Of Table In SQL
- How to calculate age (in years) based on Date of Birth and getDate()
- CROSS JOIN vs INNER JOIN in SQL
- Calculate a Running Total in SQL Server
- Difference between CTE and SubQuery?
- How to report an error from a SQL Server user-defined function
- Getting result of dynamic SQL into a variable for sql-server
- How to assign an exec result to a sql variable?
- How do I delete from multiple tables using INNER JOIN in SQL server
- How to force a SQL Server 2008 database to go Offline
- Aggregate function in an SQL update query?
- COALESCE Function in TSQL
- SQL Row_Number() function in Where Clause
- Maximum size for a SQL Server Query? IN clause? Is there a Better Approach [duplicate]
- Declare Variable for a Query String
- SQL Server Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, =
- How do you update a DateTime field in T-SQL?
- Why does Sql Server keep executing after raiserror when xact_abort is on?
- ORDER BY items must appear in the select list if SELECT DISTINCT is specified
- Conditional WHERE clause in SQL Server
- SQL Server Invalid Column name after adding new column
- What is the equivalent of the Oracle “Dual” table in MS SqlServer?
- Limit on the WHERE col IN (…) condition
- Can an INNER JOIN offer better performance than EXISTS
- Get the last day of the month in SQL
- Convert SQL Server result set into string
- Return value from exec(@sql)
- Using comparison operators in SELECT clause of T-SQL query
- IF EXISTS, THEN SELECT ELSE INSERT AND THEN SELECT
- How can I INSERT data into two tables simultaneously in SQL Server?
- Creating a stored procedure if it does not already exist
- What are the differences between T-SQL, SQL Server and SQL [duplicate]
- How to return multiple values in one column (T-SQL)?
- Executing a stored procedure within a stored procedure
- Control flow in T-SQL SP using IF..ELSE IF – are there other ways?
- How do I grant read access for a user to a database in SQL Server?
- Which is better: Bookmark/Key Lookup or Index Seek