Home Forums SQL Server 2008 T-SQL (SS2K8) returning rows within a certain distance in miles from city using longitude and latitude RE: returning rows within a certain distance in miles from city using longitude and latitude

  • Serg, It works quickly against sample data but against real life database I cancelled this query after 4 minutes 41 seconds because it didn't return anything.

    I think I should find out how to use geography datatype. If it is so great, it should also be in datawarehouse.