search for: pharm2011

...oo large to import without reducing the number of records. I do not have write access to the SQL server. mMPILatestHosp #this is my data frame of patients with unique IDs (ID) and most recent date (EVENDate) The select query is easy query<-"select * (plus columns in mMPILatestHosp) from Pharm2011 where....#This is where I want to insert mMPILatestHosp$ID in the where clause" I'm new to R so would appreciate your help. Cheers D -- View this message in context: http://r.789695.n4.nabble.com/Extracting-data-from-SQL-Server-based-on-R-parameters-tp4319919p4319919.html Sent from the R...