Re: [R] SQL> select ... where "R variable"

2011-12-14 Thread Gabor Grothendieck
On Wed, Dec 14, 2011 at 7:04 AM, agent dunham wrote: > 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 =

Re: [R] SQL> select ... where "R variable"

2011-12-14 Thread agent dunham
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

Re: [R] SQL> select ... where "R variable"

2011-12-13 Thread Gabor Grothendieck
On Tue, Dec 13, 2011 at 10:54 AM, agent dunham wrote: > Before loading sql packages, i was wondering, once all packages required are > installed, if  it's possible to do from R console sth like this: > > SQL> select v1 from sql_table >        where v2 in ("R_variable")  # being "R_variable" a vect