Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 calculating distance between two points using sql

Author  Topic 

kunaaldesai
Starting Member

36 Posts

Posted - 2009-08-15 : 20:23:14
As we know that sql server 2008 supports spatial database, I assume that it should also support some of the spatial functionalities.
is there any inbuilt function in sql server 2008 that can give me distance between two given points??

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-08-16 : 02:36:21
Yes. Search the Script Library and posts made by Michael Valentine Jones.
The new spatial datatypes do however include methods for distance calculations.



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

kunaaldesai
Starting Member

36 Posts

Posted - 2009-08-16 : 14:13:09
Thank you very peso that helped

Anything
Go to Top of Page
   

- Advertisement -