Is there a way I can use this with a variable to delete all calls before a
specific date?
Brian
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Paul Bennett
> Sent: Wednesday, July 19, 2000 4:39 PM
> To: emerald@iea-software.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" <brianj@nvc.net>
To: <emerald@iea-software.com>
> 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
> few
> > 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:
> http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart