DataRange comparision

satheesh_color · Post by **satheesh_color** » Mon Jan 19, 2009 3:05 am

Hi All,

I have the below requirement, please let me know your thoughts on this.

I have a table which contains the values for the pattern:
Store_id, Pattern, Flg, Start_Date, End_Date
123, 801, N, 20081101, 20081110
123, 802, N , 20081111, 20081125
123, 803, Y , 20081126, 99991231

One more store table contains storeid and start_date

123 , 20081115

All i need to do is check the start_date(20081115) which lies between any of the above start_date and End_Date values and get the corresponding pattern values.

Need your inputs on this.

Thanks.

kandyshandy · Post by **kandyshandy** » Mon Jan 19, 2009 5:17 am

Since you said the data is from tables, why don't you do this directly in SQL.. simple join and a WHERE clause will do this.

ray.wurlod · Post by **ray.wurlod** » Mon Jan 19, 2009 3:21 pm

Do your lookup using a database stage with user-defined SQL. Specify start_date as the Key column (it means "search key" in this context) and include the parameter marker in a BETWEEN clause in the WHERE clause.