>SQL Server: How to Insert Stored Procedure Result Set in a Table
Tables can be populated with data from result set of stored procedure. Method can be applied to regular, temporary and global temporary tables but table variables can not be populated in this fashion.
INSERT INTO [YourTableName](CommaSeparatedColumnsName)
EXECUTE YourStoredProcedureNameHere CommaSeparatedParameterValues
Note: Number of input and output columns, as well as their datatypes must be same.