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.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |