[R-sig-DB] Microsoft SQL and MARS

[Doran, Harold]

First, with apologies if this message has appeared multiple times. My company has an overly aggressive spam filter and I am not able to see if this message was previously posted.

I need to call a stored procedure on a MS SQL server that returns two tables. I am unable to find a package or function that is designed to deal with multiple tables. I have found the dbNextResult() for RMySQL, but am looking for a comparable function for SQL Server.

Am currently successfully able to query the server and return first result set table using DBI, RODBC, but not the second table.

Thank you
Harold


	[[alternative HTML version deleted]]