http://www.iea-software.com/lists/9804/emerald/00001065.htm
Ian Pizey wrote:
>
> Does any one know how to copy the calls table within the emerald
> database to another
> table that can be used for archive purposes. That in turn can be used for
> user time look ups.
>
> 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.
Many sites are using this and it works well.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com