for loop or use apply functions over a RODBC sql query

Asked Feb 23 '17 at 08:47

Active Feb 23 '17 at 09:18

Viewed 281 times

Let's say I require a distinct count for each year with specific criteria as per where statement and x below being various years 2000 to 2016:

dbGetQuery(conn, "SELECT COUNT(DISTINCT ID)
                  FROM table x
                  WHERE cust_STATUS_DESC like '%matured%'
                  and YEAR(END_DATE) in ("x") ") )

How do I do this using a for loop or apply function?

edited Feb 23 '17 at 09:18

zx8754

52,746
12
114
209

asked Feb 23 '17 at 08:47

Learner_seeker

Try something like `res <- lapply(2010:2015, function(x) dbGetQuery(conn, paste("SELECT .... in", x ")")` – zx8754 Feb 23 '17 at 09:22
I am getting the Error: unexpected string constant in: – Learner_seeker Feb 23 '17 at 09:58
Edit your post with more detail, paste your code, and error message. – zx8754 Feb 23 '17 at 10:02

for loop or use apply functions over a RODBC sql query

0 Answers0