hi. can you give more details ? how is effective_price for today calculated - for example if u need price for 11th oct 2006, i'm assuming all u need is the price for date_from / date_to when there's a match in the range.
yashesh bhatia. On 10/7/06, abhishek jain <[EMAIL PROTECTED]> wrote:
Hi, I have a table like : ID date_from date_to price_code price dateadded 1 07:10:2006 31:12:2099 p1 10 07:10:06 2 17:10:2006 31:12:2099 p1 20 07:10:06 3 27:10:2006 31:12:2099 p1 10 07:10:06 4 01:11:2006 31:12:2099 p1 20 07:10:06 5 05:10:2006 31:12:2099 p1 20 08:10:06 6 10:10:2006 31:12:2099 p1 20 08:10:06 7 25:10:2006 31:12:2099 p1 20 08:10:06 Basically there are price codes and the price , i have to find the effective price for the date today. The price must be calculated also on the latest added date. Pl. help me. I shall be very grateful. -- Regards, Abhishek jain
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]