[R] RODBC results from stored procedure

[ang]

I know this thread is from a while back, but hopefully I can still get some
help on this.

I also used RODBC to connect to a SQL Server, and my stored procedure
returns a results set (that is not stored as a temp or permanent table).

So I was wondering if there was a way to access this results set, or am I
forced to store the results into a table before I can access it?

Some options I have considered: 
a)modifying the stored procedures to insert the results into tables
b)creating temp tables (trying to stay away from this as it is not as
dynamic and would require defining of many tables if I wanted to run some ad
hoc analysis)

The reason I do not want to modify the queries/create temp or perm tables is
because the SQL end is maintained by a separate team, and I am simply using
R to connect/run analyses off the data.  I am trying to keep my side as self
contained and independent as possible.  Any suggestions/advice would be
greatly appreciated.

Thanks a lot,
Adrian
-- 
View this message in context: http://r.789695.n4.nabble.com/RODBC-results-from-stored-procedure-tp897462p2996173.html
Sent from the R help mailing list archive at Nabble.com.