I am trying to insert multiple insert statements through R using RODBC. Initially Every time I am creating Insert statements and executing queries one by one.This takes lot of time since everytime the query is created and inserted. Is there any other way So that I can insert Multiple Insert statements in a single execution. I have tried Option for sqlSave, But in the parameters databasename is not mentioned. So it is trying to create table in a master database. But I need to create table and insert statement in mydatabase and table. How is it possible ?
-- View this message in context: http://r.789695.n4.nabble.com/Inserting-multiple-queries-in-sql-server-2005-using-RODBC-in-R-tp3066744p3066744.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.
