Posted by Pacific Fox on 11/14/06 22:45

Hello all,

Does anyone know the SQL statement for calculating surrounding suburbs,
or can point me in the right direction?
I have a database of Australian postal codes and their centroids in
longitude and latitude, I'd like to pass it either the long/lat or
postal code to calculate from. And preferably return distance as well,
in KM..

Thanks in advance.

• Next in forum: problem with trusted connection (asp.net)
• Prev in forum: Re: where DTS in SQL 2005; Oracle to SQL2k5??
• Thread view: SQL to calculate surrounding suburbs

[Reply to this message]