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...