Re: small problem

Dale E. Reed Jr. ( (no email) )
Sat, 2 May 1998 21:55:33 -0700 ()

On Sat, 2 May 1998, S.K. de Graaf wrote:

> 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