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
Koen Verbeeck
SSC Guru
Points: 259085
More actions
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 questionMy blog at https://sqlkover.com.MCSE Business Intelligence - Microsoft Data Platform MVP