I've got the same issue that you do. Here is my thinking thus far:
Say I have a transaction table:
Record_Key
Service_Date
Item_Code
Item_Quantity
I'm considering this structure for the rate table:
Item_Code
Effective_Date
Rate
It's practical from a data entry perspective, but I can't seem to
SELECT price FROM mytable WHERE price = theprice DESC LIMIT 1;
-Original Message-
From: Alejandro Zuzenberg [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 01, 2001 7:53 PM
To: [EMAIL PROTECTED]
Subject: Can I use the concept of Effective Date with MySQL?
I need to select the
I have had to do this problem and i solved it by having 4 fields,
Normalprice (PrPrice),
Tempprice (PrTempPrice),
Start date (PrStart)
End Date (PrStop).
In the select
IF(((CURDATE() = PRStart) and (PRStop = CURDATE())),
PrTempPrice, PrPrice) as CurrentPrice
hope this helps
On Thu, 1 Nov