[R] Help: sqlSave Error

2011-11-09 Thread bruclee
I am using sqlSave to save my data into an existing table at MS SQL Server database. Previously my code ran smoothly but all of a sudden it stopped working. Here is my code: sqlSave(con, highVol, "dbo.futuresHighVol", append=TRUE, rownames=FALSE) Error: sqlSave(con, highVol, "jrgchis.dbo.futuresH

Re: [R] Help: Using vectorization method for vectors comparision

2010-10-20 Thread bruclee
Very Nice! Thanks a lot! Btw, I think "match" function should also do the work for the last two steps. :) -- View this message in context: http://r.789695.n4.nabble.com/Help-Using-vectorization-method-for-vectors-comparision-tp3004952p3005032.html Sent from the R help mailing list archive at Na

[R] Help: Using vectorization method for vectors comparision

2010-10-20 Thread bruclee
I am trying to compare two sorted vectors, all elements in both vectors are not duplicated. Ex. a = c[5, 10, 13, 19, 23] b = c[1, 4, 7, 9, 15] For each element in a, i need find the max element in b which is smaller than it, so the short answer will look like [4, 9, 9, 15, 15]. I dont want to use