Each time you call that second stored proc it returns a recordset. Analyzer displays all of these recordsets for you, but using ado it brings back the first one. I believe there is a way for ado to bring back multiple recordsets, but its not going to bring back 1 with all of the combined data. Try using a Union.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.