Re: Runtime for deleteing lots of records

[Evan Harris <spanner@xxxxxxxxxx>]

It look like a yymmdd field to me, but then I expect that am used to siing 
that format ;) If you are right and its a date field then I read it as 
records after 1/1/2000 and less than 1/2/2002.

Regards
Evan Harris

> I am a bit worried about the logic of this statement.  Those numbers look
> suspiciously like mmddyy dates.
>  It would seem to me you have just deleted all the records for January and
> February (through the 8th) of every year including this year, and kept all
> of the records of every year if the day was greater than February 9th.
> Obviously that isn't so as you deleted 8/11 of the file, but I am very very
> suspicious of the results of your SQL.
>
>
> ---------------------------------------------------------
> Booth Martin   http://www.MartinVT.com