Distance between two points across the ground using sql server

Question

I want to calculate the shortest distance between two points inside SQL Server 2008 based on the mass of the earth.

I used the geography data type along with STDistance () to work out point x to point y when the crow is flying, however sometimes it crosses the sea, which I am trying to avoid.

I also created a polygon around the border of the land mass that interests me.

I believe that I need to combine these two methods to ensure that STDistance always remains within the polygon - unless there is a simpler solution.

Thanks for any advice.

Answer 1

STIntersects - http://msdn.microsoft.com/en-us/library/bb933899%28v=SQL.105%29.aspx, , .

. , SQL Server . , " ", .

, , ( ) . , , . . :

http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=cost_path

!

http://bit.ly/ckvciz

, . API Google Directions API , .

http://code.google.com/apis/maps/documentation/directions/