Insert Table To Stored Procedure Return Multiple Recored

        SELECT  *
        INTO    #MyTable
        FROM    OPENROWSET('SQLNCLI',
                           'Server=ServerName;Database=DataBaseName;Uid=UserName;Pwd=Password;',
                           'StoreProcedureName ') ;