Thank you,
I guess it didn't work for me, maybe is not possible?
I've tried:
> con<- odbcDriverConnect("Driver=SQL Server;
> Server=...\\...;Database=...;Uid=...;Pwd=... ;")
> v1=sqlQuery(con, "select v1 from sqltable where v3 =cte and v2 in (select
> v2 from R_dataframe) order by (select v2 from R_dataframe)")
> head(rbind(R_dataframe$v2, v1))
[,1]
"1251"
v1 "42S02 208 [Microsoft][ODBC SQL Server Driver][SQL Server]*The name of
the object 'R_dataframe' is not valid.*"
Thanks in advance,
u...@host.com
--
View this message in context:
http://r.789695.n4.nabble.com/SQL-select-where-R-variable-tp4190882p4194629.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
