e number of rows
against which the sqrt(pow... stuff could limit down further into a circle.
the <, >, expressions could use indexes whereas the sqrt/pow stuff can't.
greg.
>
> From: "Leo G. Divingracia III" <[EMAIL PROTECTED]>
> Subject: Re: Trouble convertin
Asendorf, John wrote:
.
SELECT Dealers.*, SQRT(POW((2285-Zips.North),2)+POW((4760-Zips.West),2)) AS
Distance
FROM Dealers
INNER JOIN Zips ON Dealers.Zip = Zips.Zip
ORDER BY POW((2285-Zips.North),2)+POW((4760-Zips.West)),2)
Any suggestions to speed this guy up?
yeah, do you really need ALL the
:[EMAIL PROTECTED]]
> Sent: Friday, December 27, 2002 1:12 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Trouble converting SQL from Access
>
>
> OK, I've figured out how to fix the SQL (was searching for
> "equations" and
> "calculations
On Fri, 27 Dec 2002 13:11:42 -0500, Asendorf, John wrote:
>SELECT Dealers.*, SQRT(POW((2285-Zips.North),2)+POW((4760-Zips.West),2)) AS
>Distance
>FROM Dealers
>INNER JOIN Zips ON Dealers.Zip = Zips.Zip
>ORDER BY POW((2285-Zips.North),2)+POW((4760-Zips.West)),2)
Off the top of my head have
740-349-3631
Nullum magnum ingenium sine mixtura dementiae fuit
> -Original Message-
> From: Asendorf, John [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 27, 2002 10:03 AM
> To: [EMAIL PROTECTED]
> Subject: Trouble converting SQL from Access
>
>
> I'm att
