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 -~----------~----~----~----~------~----~------~--~---
