Alex Rivera | Logout

Access second result set of stored procedure with SQL or other work-around? Python\pyodbc

Asked 2008-11-07T18:58:47.633
16

I'm using python\pyodbc and would like to access the second result set of a stored procedure. As near as I can tell, pyodbc does not support multiple result sets. Additionally, I can't modify the stored procedure. Are there any options to access the second result set using SQL or some other work-around? Perhaps create a second stored procedure that only returns the second result set of the first?

python sql pyodbc
Edit
Report

1 Answer

0

There are a few possible methods here. If the result sets are all the same, you might be able to use the INSERT...EXEC method. Otherwise OPENQUERY might work.

answered 2008-11-07T19:43:29.553

Your Answer