Re: Call History script

jmercer ( (no email) )
Thu, 04 Jun 1998 14:34:26 -0500


What would be the SQL to do this with an access database.

*********** REPLY SEPARATOR ***********

On 6/4/98, at 11:48 AM, Dale E. Reed Jr. wrote:

>On Thu, 4 Jun 1998, Peter D. Mayer wrote:
>> Does anyone have a good call history script for MSSQL? I'm looking for
>> most efficient way to get rid of call table records while still keeping
>> on total time logged in. I was thinking maybe one record per user per
>> 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
>From Calls
>Where CalLDate >= '5/1/98'
> and CallDate < '6/1/98'
> and AcctStatusType = 2
>and then delete based on just the date range.
>Dale E. Reed Jr. (
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today |

Jerry Mercer
Internet -