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.
__________________________________
Ian Pizey
Technet of Kenora Inc.
924 5th Street South
Kenora, ON P9N 1L8
Ph 807-468-8900
Fx 807-468-7700
email:ifpizey@kenora.com