ability to get table var from result class

[adamfoneil]

Sometimes I will need a table variable mapped to a result class. The situation is when I need to insert proc results into a table var because I need it for a join in a larger query.

DECLARE @myTable TABLE (
    [Id] int NOT NULL,
    [Code] nvarchar(50) NOT NULL
)

INSERT INTO @myTable EXEC [dbo].[MyProc]

In the example above, I need it to generate the @myTable var by inspecting the proc output.