Re: Call History script

Dale E. Reed Jr. ( (no email) )
Thu, 4 Jun 1998 11:48:15 -0700 ()

On Thu, 4 Jun 1998, Peter D. Mayer wrote:

> Does anyone have a good call history script for MSSQL? I'm looking for the
> most efficient way to get rid of call table records while still keeping data
> on total time logged in. I was thinking maybe one record per user per month
> with total time? I'm interested in hearing how other people handle call
> history.

If you crreated a second table like "CallHistory" (like what Emerald
uses) you could them do something like this:

Select Username, CallDate='5/1/98', Mins=Sum(AcctSessionTime/60+1)
Into CallHistory