Hi Robin, First of all, let me tell you that I am not smart enough to even begin to understand how that calculation works, I've just copied it from somewhere, figured out what makes it work and translated it to SQL. Other than that I don't even know if it is the right way of doing it (obivously not), it seemed to return the right results though.
So, if you could find the time to explain to me how I can improve on the above query that would be very much appreciated. Thanks. Robin Hilliard wrote: > On 15/11/2006, at 11:27 AM, Taco Fleur wrote: > > > I am able to retrieve surrounding suburbs with the following SQL > > statement, but have no idea how to retrieve the distance in that > > same SQL statement, does anyone know? > > > Couldn't you do something like this: > > SELECT suburb, postalCode, ROUND(...) as distance > FROM dbo.postalcode_centroid > WHERE distance <= @radius > > BTW over small distances (unless you're talking avionics) you don't > really need to use the great circle algorithm - if performance is > important to you just use pythagoras. > > > > Cheers, > > Robin --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
