RE: Need Quick script for deleting calls records!

Tom Bilan ( Tom@tdi.net )
Sat, 7 Mar 1998 20:11:56 -0500

delete from calls where acctstatustype = 1

Tom

> -----Original Message-----
> From: Barry Kiesz [SMTP:barry@hdc.net]
> Sent: Saturday, March 07, 1998 7:35 PM
> To: Emerald@iea-software.com
> Subject: Need Quick script for deleting calls records!
>
> Does anyone (Dale) have ,or could kick out quickly, a SQL script that
> would
> delete the Radius start records in Emerald.. Our Calls records is now
> up to
> 800,000 and it's getting a little slow when we look up someone's time
> on....
>
>
>
> Regards,
>
> Barry
>
> ------------------------------
> Barry Kiesz IS Manager
> Hard Drive Central Aberdeen, SD
> barry@hdc.net
> 605-229-1562 Voice
> 605-229-1563 Fax
>
> ------------------------------
>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com