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,
Hi,
I have a table like :
ID date_from date_to price_code price dateadded
1 07:10:2006 31:12:2099 p11007:10:06
2 17:10:2006 31:12:2099 p12007:10:06
3 27:10:2006 31:12:2099 p11007:10:06
4 01:11:2006 31:12:2099 p12007:10:06
5 05:10:2
