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