The table would have a different name and contain the same structure and
data as the current table. i asssume that once the table is created a
nightly trigger can update this table and therefore have near on line time
available for the users. I realize that the purpose of the consolidation
process is to reduce the amount of data in the calls table. However the
need for online time checking does save a needless administrative burden
and provides the customers with better service.
A response would be appreciated.
Technet of Kenora Inc.
924 5th Street South
Kenora, ON P9N 1L8