KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I've looked at the ' Pass R variable to RODBC's sqlQuery with multiple entries? ' already but can't seem to get it to work. I'm trying to do an sqlQuery() from R on a SQL Server 2008 R2 db. I'm trying to get a sample from a large db based on row numbers. First I created a list of random numbers: sampRowNum <- sample(seq(1,100000,1), 5000) Then I try to use those numbers in a query using: query1 <- sqlQuery(channel, paste("select * FROM db where row_id in (", sampRowNum,")", sep="")) I get just the results from the db where the row_id is equal to the first number in sampRowNum . Any suggestions?
Tags (comma-separated)
Save Edits
Cancel