• Well - temp tables are certainly one way... but they're not the ONLY way.

    depending on what you want to do with them, you can set up a "self-linked server" and then use them a bit like table-valued functions and access their output as a table variable.

    As in - something like

    Select *

    from openquery(MyLocalServer, 'exec mydbo.dbo.myStoredProc @Param=1')

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?