Displaying 1 result from an estimated 1 matches for "rtnsunderscor".
Did you mean:
rtnsunderscored
2009 Jul 15
1
RODBC results from stored procedure
...quot;select * from returns order by Date asc")
[...success...]
>head(dbdata)
Date Asset1 Asset2....
2009-07-10 0.01 0.02
2009-07-13 0.007 -0.003
...
I'd appreciate any suggestions,
Andrew
W
rm(dbdata)
#run query in query analyzer and get date from rtnsUnderscored table
#dbdata<-sqlFetch(conn,sqtable="sp_GetModelRtns4OptimizeRangeVer4
5000,'2001-10-01','2009-07-14")
#dbdata<-sqlFetch(conn,sqtable="sp_GetModelRtns4OptimizeRangeVer4
5000,'2009-07-01','2009-07-14")
dbdata<-sqlQuery(conn,"select * from...