----- Original Message -----
From: "Brian Johnson" <brianj@nvc.net>
To: <emerald@iea-software.com>
Sent: Wednesday, July 19, 2000 4:46 PM
Subject: RE: [Emerald] Calls Table Dump
> Thank you Oh holy and wise one. It worked Great! 8^)
>
> 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
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart