Without write access to the SQL database, you cannot merge data from both
sources within the SQL query. You can use paste to build a list of literal
strings that you can refer to in the SQL where clause with IN, pull the results
into R, then use the merge function to combine the data frames in R
Hi,
Can you extract data from a SQL server table based on parameters already in
R? For example I have a list of unique patient IDs with latest
hospitalisation date which I've processed in R. I need to join this data to
other tables in SQL server. The tables in SQL server are too large to import
wi
2 matches
Mail list logo
