Post reply

Multiple Recordsets output into an SP

  • June 15, 2006 at 3:22 am

    #91557

    We have a core SP that returns multiple related recordsets to our applications. We can join these recordsets in our application code fine. But now I want to call the SP from another SP and join the results using SQL/T-SQL.

    Is this possible?

    Any help appreciated, thanks.

  • June 15, 2006 at 3:35 am

    #643892

    Dominic,

    Unfortunately that is not possible. In this kind of situation, where you need to manipulate the resultset returned from an sp using T-SQL, the best approach is to manipulate it within the stored procedure itself and it have it return a single resultset that conforms to the output that you ultimately want.

    In other words, do the joining within the stored procedure and return one resultset.

    It's a bit difficult to offer any more advice though without an idea of what it is you're trying to achieve but I hope that helps.

    Karl
    source control for SQL Server

  • June 15, 2006 at 3:37 am

    #643893

    I though So.

    Thanks for your help.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply