[R-sig-DB] Microsoft SQL and MARS

[Juan Telleria Ruiz de Aguirre]

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 using 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 using r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>

	[[alternative HTML version deleted]]