Home Forums SQL Server 2005 SQL Server Newbies Problem excecuting store thats return multiple result sets RE: Problem excecuting store thats return multiple result sets

  • October 23, 2013 at 2:10 pm

    #1661094

    Since you mention datatable, I assume you're using .NET?

    Take a look at MARS (multiple active result sets):

    Manipulating Data

    http://stackoverflow.com/questions/6043685/can-we-return-a-multiple-result-set-in-stored-procedure-and-how-to-handle-it-in

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP