In SQL Server 2016, there's a stored procedure that has an EXEC statement. I want to use the recordset output from that stored procedure in another stored procedure, but due to the limitations of SQL Server I can't use it in a FROM clause, and I also can't Insert the recordset into a table variable (can't have nested EXEC's). I also can't put the programming of the original stored procedure into a table valued function so I can use the output recordset in a FROM clause because you can't use EXEC in a function. How can I use the recordset in a stored procedure? Is a temporary table an option?