Calculate distance in miles between two coordinates

Other SQL Server Topics
3

Hi @Kristen,

Thank you for your response.

I just need a relatively accurate mileage distance calculation.

Can you help me to construct one using Pythagoras? (or any other calculation that would give me the same result).

So assuming we have a point A with Lat=57.148239, Lon=-2.096668 and point B with Lat=57.148088, Lon=-2.094684, I need a query that will calculate the distance in miles between A and B.

Thanks