How can I measure the distance between 2 customers. For example, One customer is at Point A with Latitude of 42.91 and Longitude of -77.70 and the other is at Point B with Latitude of 42.09 and Longitude of -80.12.
I am using SqlServer 2012.
The data resides in my table in the following manner:
Customer Lat (float) Long (float)
1 42.91 -77.70
2 42.09 -80.12