spTwo

USE tempdb
GO

CREATE PROC spOne
    @showResults BIT = 1
AS
BEGIN

    SET NOCOUNT ON

    SELECT *
    INTO ##mytemptable
    FROM sys.objects

    IF @showResults = 1
    BEGIN
        SELECT *
        FROM ##mytemptable
    END

END
GO

CREATE PROC spTwo
AS
BEGIN

    SET NOCOUNT ON

    EXEC spOne @showResults = 0;

    SELECT *
    FROM ##mytemptable
    WHERE CAST(object_id AS VARCHAR(10)) LIKE '0%'

END
GO

--The data set I'm trying to add
EXEC spTwo