RE: Consolidation

Ronnie D. Franklin ( ronnie@itexas.net )
Wed, 25 Feb 1998 09:14:19 -0600

Thanks!! I got rid of 51000+ records!!

On Wednesday, February 25, 1998 1:46 AM, Dale E. Reed Jr. [SMTP:daler@iea-software.com] wrote:
> Ronnie D. Franklin wrote:
> >
> > Due to some problems with the bit clock at the telephone CO and folks not
> > getting connected I have a ton of records in the Calls Table that have a 0
> > AcctSessionTime. I would like to delete all those records prior to doing
> > consolidation...
> >
> > Is it safe to do a query to delete them or do I need to reference another
> > table??
> >
> > Also, before writing the query, anyone already have one????
>
> Its safe:
>
> Delete From Calls Where AcctSessionTime = 0
>
> --
> 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
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com