Displaying 1 result from an estimated 1 matches for "l5_product_hierarchy_code".
2012 Feb 15
1
Passing date as parameter while retrieving data from database using dbGetQuery
...,format="%Y-%m-%d")
end_dt <- as.Date('2011-01-31',format="%Y-%m-%d")
library(sqldf)
target_population <- dbGetQuery(conn,
"select distinct
a.primary_customer_code as cust_id,
a.primary_product_code,
a.account_opening_date,
b.l4_product_hierarchy_code,
b.l5_product_hierarchy_code
from account_dim a,
product_dim b
where a.primary_product_code=b.l5_product_hierarchy_code
and a.account_opening_date between start_dt and end_dt")
####################################################################
As it is not possible to reproduce error with the above code, I am providin...