Is there a way I can use this with a variable to delete all calls before a
> -----Original Message-----
> From: email@example.com
> [mailto:firstname.lastname@example.org]On Behalf Of Paul Bennett
> Sent: Wednesday, July 19, 2000 4:39 PM
> To: email@example.com
> Subject: Re: [Emerald] Calls Table Dump
> if you want to clear the whole thing just use this
> TRUNCATE TABLE Calls
> only takes a few seconds and its totally empty
> ----- Original Message -----
> From: "Brian Johnson" <firstname.lastname@example.org>
> Sent: Wednesday, July 19, 2000 4:35 PM
> Subject: [Emerald] Calls Table Dump
> > I want to completely empty my calls table.
> > I have run the following script, but It keeps timing out...
> > Delete
> > From Calls
> > Where CallDate < '6-1-2000 00:00:00'
> > The table has more than 2,000,000 records.
> > I am looking for a quick way to dump the entire table. By quick I mean A
> > minutes max.
> > Brian 8^)
> > For more information about this list (including removal) go to:
> > http://www.iea-software.com/support/maillists/liststart
> For more information about this list (including removal) go to:
For more information about this list (including removal) go to: