Re: Problems with script...

Dale E. Reed Jr. ( (no email) )
Fri, 12 Dec 1997 10:18:53 -0800

Robert Boyle wrote:
> >calldate>="12/10/97" and calldate<="12/11/97" will output everybody who

> Select * From Calls Where DatePart(Month, CallDate)=12 and DatePart(Day,
> CallDate)=3 and DatePart(Year, CallDate)=1997 and
> FramedAddress=''

Logically, the first should be faster, since its only two compares
per record. DatePart() is going to have even a higher overhead,
since the first is just comparing two longs, where as datepart()
has to disect the date, break it up, and then compare, three
times actually. :(

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |