How we saving two different result from one SP into two different table

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[^]