search for: sadatetim

...have a date of sampling and a value. I want to put everything in a list such that for each sampling point (say OS1) I have two columns (date, time). I use the function sqlQuery from the RODBC package. Here is an example that works: OxygenMeasurements$OS1 <- sqlQuery(channel, "SELECT saDateTime, sdValue FROM dbo_Sample WHERE (paID = 213) AND (stCode ='OS1');") To keep the code "elegant" and, above all, short I try to regenerate the same function call with a different query statement for each sampling point by using the paste() function. (1) sqlquer...