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
Microsoft SQL and MARS
2 messages · Doran, Harold, Juan Telleria Ruiz de Aguirre
12 days later
A good strategy would be to store the Stored Procedure Results into temporary tables, and afterwards, query both of those tables in different queries through SELECT statements. In odbc package that would mean calling two different dbGetQuery Statements with different SELECTs. Best, Juan El viernes, 3 de abril de 2020, Doran, Harold <HDoran at air.org> escribi?:
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]]
_______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB at r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-db