[R-sig-DB] Microsoft SQL and MARS
Doran, Harold
HDor@n @end|ng |rom @|r@org
Fri Apr 3 13:00:34 CEST 2020
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]]
More information about the R-sig-DB
mailing list