search for: sp_getreturn

Displaying 1 result from an estimated 1 matches for "sp_getreturn".

Did you mean: sp_getreturns
2009 Jul 15
1
RODBC results from stored procedure
.... Then I was able to make second call to sqlQuery with a simple select statement for the results table and retrieve the results back into R. My question is: can I get stored proc results directly back to R without having to populate and query a results table? >dbdata<-sqlQuery(conn,"sp_GetReturns,'2009-07-10','2009-07-14'") >head(dbdata) character(0) [....no data here....] >dbdata<-sqlQuery(conn,"select * from returns order by Date asc") [...success...] >head(dbdata) Date Asset1 Asset2.... 2009-07-10 0.01 0.02 2009-07-13...