[Emerald] Purging calls table

Emerald ( (no email) )
Sun, 12 Sep 1999 11:01:21 -0400

Dale, other SQL experts,

Problem, we bill people for use of our 800 number (a surcharged service
based on usage), and purging the calls table every month or every 3 month
will delete records that are needed to bill semianual or yearly billing

Would it be possible to write an SQL script that only purges the calls from
the calls table that have already been billed (the ones that don't matter
anymore)? I'd like to keep the table trimmed down (we have way too much
traffic to keep a years worth) but I'm not good enough to write a script
like this. Anyone done this yet?


For more information about this list (including removal) go to: