Re: Consolidation
Dale E. Reed Jr. ( (no email) )
Tue, 24 Feb 1998 23:46:04 -0800
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