First make sure you have cleared out all your start records.
Those are AcctStatusType = 2 records. You can see how many you
have by doing a:
Select Count(*) From Calls Where AcctStatusType=1
Typically, this will half your calls table. I posted a message
earlier about having an appropriately sized tempdb database to
handle the consolidation. Something around 5-15mb should be fine.
I might add an option to the charges consolidation to allow stepping
of it, rather than having to do all of it as it currently does.
-- Dale E. Reed Jr. (daler@iea.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com