Re: [R] Avoiding multiple outputs using RODBC package

2008-12-15 Thread Prof Brian Ripley
On Sun, 14 Dec 2008, Mark Wardle wrote: Hi. You don't need to download the whole of the output database table to look for an already generated answer. You can write a SQL query to do that instead. ie. give me any rows with these parameters... Get the database to do the work - it is what they a

Re: [R] Avoiding multiple outputs using RODBC package

2008-12-14 Thread Mark Wardle
Hi. You don't need to download the whole of the output database table to look for an already generated answer. You can write a SQL query to do that instead. ie. give me any rows with these parameters... Get the database to do the work - it is what they are designed to do. So the procedure is: 1

[R] Avoiding multiple outputs using RODBC package

2008-12-12 Thread Brigid Mooney
I am using R as a data manipulation tool for a SQL database. So in some of my R scripts I use the RODBC package to retreive data, then run analysis, and use the sqlSave function in the RODBC package to store the results in a database. There are two problems I want to avoid, and they are highly re