> However not all records in the table are cleaned in this process.
> There wil remain entries from users wich have been deleted from the MBR's
>
> Is there a way or script to completely clean the table every month
> after the batch?
Basically, you can just delete records before a given date like:
Delete From Calls Where CallDate < '2/1/98'
or whatever the date you want is. Generally about two
months back if you are doing a full consolidation would be
sufficient.
Dale