Arthur Fuller
fuller.artful at gmail.com
Wed May 7 11:19:48 CDT 2014
Darryl, Nice example. Thanks for offering it. Arthur > There is no way in hell you are going to do something like "UPDATE > GST_RATE to .15" globally and have it work. > > You need to have a table live (Using GST_RATE as the example here) > > StartDate | EndDate | Rate > 1-Jan-2001 31-Dec-2001 0.05 > 1-Jan-2002 31-Jul-2004 0.07 > 1-Aug-2004 31-Dec-2006 0.85 > 1-Jan-2007 31-Jul-2007 0.67 > Etc... > > Cheers > Darryl