You can't access the separate result sets in T-SQL.
You can do it in code e.g. Return the results to a .NET DataSet and you will be able to access the tables. Example
How to: Execute Stored Procedures Returning Multiple Result Sets[
^]
If both result sets have the same schema then you can save all of the output into a temporary file and then split the data out based on whatever criteria you want Example:
CREATE PROCEDURE [dbo].[sp_TwoResults]
AS
BEGIN
SELECT 'table', TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
SELECT 'column', COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS
END
GO
CREATE TABLE #temp(ObjectType varchar(6), ObjectName Varchar(50))
INSERT INTO #temp
EXEC sp_TwoResults
select * from #temp
Better would be to alter the stored procedure to put the outputs directly into the target tables or have two stored procedures -
Stored procedures and multiple result sets in T-SQL[
^]