Stored Procedure Modification

your question is a bit vague so my answer is a bit of a guess but maybe you want something like this:

-- Modify Stored procedure 
ALTER PROCEDURE [dbo].[uspSPName]
    @VariableName [int]
AS
BEGIN
    SET NOCOUNT ON;

    SELECT *
	FROM [dbo].[tableName]
END;

-- Select SP results 
INSERT INTO #tmp EXEC [dbo].[uspSPName]

-- DELTA Load
 MERGE mergeTable AS tgt
    USING (SELECT * from #tmp) AS src(id, name)
        ON (tgt.id = src.id)
    WHEN MATCHED
        THEN
            -- RUN UPDATE STATEMENT 
    WHEN NOT MATCHED
        THEN
            -- RUN INSERT STATEMET