At 10:52 AM 7/21/97 -0700, you wrote:
>Wayne Jordan wrote:
>>
>> We are going to change most of rates pretty soon to hourly, which will also
>> increase user fees. What I'd like to do is analyze what the aveage monthly
>> usage is for each customer then I'd like to clear all of the call history
>> out of the database. Does anyone have any idea on how to do this?
>
>I wrote a query somewhere around here to do that. Do you want just the
>straight average or average of each user?
>
>"Truncate Table Calls" and/or "truncate table callhistory" should
>work.
>
>--
>Dale E. Reed Jr. (daler@iea.com)
>_________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.emerald.iea.com
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>
>