No announcements

### Compute distance between two points and return as new field in query results. SQL R2 GEOGRAPHY

OK this doesn't seem to work - the Management Studio doesn't' like the AS or something what should it be ? I want to return all the records ...
| 2 Replies | 11492 Views | Created by Mothermugger' - Wednesday, July 27, 2011 9:12 PM | Last reply by Mothermugger' - Thursday, July 28, 2011 10:42 AM

### Compute distance between two points and return as new field in query results. SQL R2 GEOGRAPHY

This is working great - but now how do I get a new field for each record in the return query that shows the number of miles each ...
| 1 Replies | 12215 Views | Created by Mothermugger' - Wednesday, July 27, 2011 9:02 PM | Last reply by Andrés N. García - Monday, November 26, 2012 10:24 PM

### Geography between two points

How to count geographic cooridnate in the middle between two points? Probably, I can't use following equations: (g2.Lat - p1.Lat) / 2 + ...
| 4 Replies | 13778 Views | Created by Sławomir Rosiek - Saturday, July 12, 2008 5:30 PM | Last reply by Isaac Kunen - Monday, July 14, 2008 3:47 PM

### Distance between two points

coordinates on the route and then loop through the points in between and calculate the sum of the distances between each coordinate. To ...
| 5 Replies | 8929 Views | Created by Gabriele Guerra - Saturday, October 2, 2010 11:42 PM | Last reply by tanoshimi - Friday, September 9, 2011 10:52 AM

### Distance between more points

distance between all points in "Table A" and "Table B". I tried .STDistance(select * from Table) instead of ...
| 2 Replies | 9456 Views | Created by RPJH - Monday, February 22, 2010 11:58 AM | Last reply by RPJH - Monday, February 22, 2010 1:37 PM

### Calculating distance between two points

no pow(foo, 2) here because A and B are different?  So the clarity for me, in this case, came from the original dx * dx of the inner product as opposed to ...
| 23 Replies | 39923 Views | Created by _Yoshi_ - Monday, August 30, 2010 5:36 PM | Last reply by kbanman - Monday, December 21, 2015 7:03 PM

### Creating static class: Distance between two points

Hi all, I am trying to create a static class that calculates the distance between two ...
| 4 Replies | 830 Views | Created by Shonie242 - Monday, October 20, 2014 4:38 AM | Last reply by Shonie242 - Monday, October 20, 2014 5:52 AM

### Distance between 2 points

Hello,   I have compute a distance between 2 points, and i compare my result with a famous web site mappy.fr, and i hace ...
| 2 Replies | 3581 Views | Created by topolino - Monday, October 27, 2008 5:26 PM | Last reply by Derek Chan Old - Wednesday, October 29, 2008 8:02 PM

### Distance between two points lat/long

I have a user defined function, I want to determine the distance between the 2 points. I have it working but i'm having a problem getting to print.
| 2 Replies | 11806 Views | Created by Brian Davisson - Saturday, January 12, 2008 8:01 AM | Last reply by Brian Davisson - Sunday, January 13, 2008 4:56 PM

### Distance between 2 points

HypothenuseLength As Double = (Math.Sqrt((rect.Width * rect.Width) + (rect.Height * rect.Height)))         Return ...
| 8 Replies | 3652 Views | Created by Lawrex - Sunday, February 4, 2007 3:31 PM | Last reply by ReneeC - Monday, February 5, 2007 12:00 AM

### Calculate Distance between 2 points

But, there are several instances in the application where i do not ned routes at all. All i need is travel distance between 2 addresses.(Latitude and ...
| 10 Replies | 8847 Views | Created by rowter - Monday, April 19, 2010 10:25 PM | Last reply by Ricky_Brundritt - Wednesday, April 21, 2010 9:30 PM

### How to find distance between two points on earth

hi All, I want to calculate the distance (in meters) between two points whose latitude and longitude will be entered by the ...
| 2 Replies | 3460 Views | Created by Anky.NET-o-Mania - Saturday, August 8, 2009 12:10 PM | Last reply by Anky.NET-o-Mania - Monday, August 10, 2009 9:41 AM

### Find distance between 2 points

This query works fine for me as long as I have valid values. Is it possible that one of the rows in the UG or RG tables contain NULL ...
| 1 Replies | 3020 Views | Created by RonTech1 - Tuesday, August 4, 2015 9:14 AM | Last reply by Bob Beauchemin - Tuesday, August 4, 2015 6:49 PM

### Huge difference between geography and geometry results

Your first result is in metres, the second is in degrees (of latitude/longitude). If you want to get similar results from the geometry and ...
| 3 Replies | 13586 Views | Created by sqlblr - Tuesday, July 5, 2011 1:33 PM | Last reply by tanoshimi - Thursday, July 7, 2011 6:20 AM

Is there a way to find out the driving distance between two given addresses without plotting the route? We have a list of addresses and we
| 3 Replies | 8015 Views | Created by KedarParalkar - Wednesday, November 1, 2006 8:50 PM | Last reply by KedarParalkar - Monday, November 6, 2006 7:00 PM

### Distance between two postcodes

Hi thanks for the replies. I am using MapPoint to caliculate distance and driving time between two ...
| 6 Replies | 7136 Views | Created by VBE_programmer - Monday, May 14, 2007 10:17 AM | Last reply by VBE_programmer - Monday, May 14, 2007 3:32 PM

### Calculate distance between tow points

Dears, I want to create windows application form to allow user to draw two points only and draw line between those two points ...
| 5 Replies | 409 Views | Created by Yasser Zaid - Tuesday, January 26, 2016 8:34 AM | Last reply by Yasser Zaid - Wednesday, January 27, 2016 5:36 AM

### Calculating distance between two points, using latitude longitude?

I am trying to calculate distance between two points using java code, I have written a code but it is not working. I have checked various forums to ...
| 1 Replies | 792 Views | Created by Ranjeet.K - Thursday, July 9, 2015 9:00 AM | Last reply by Guillaume Rouyre [MBA, MVP, MCC] - Thursday, July 9, 2015 9:47 AM