Hello - I am looking to get the distance between two columns in SQL Server.
I have 1 table only
The table has two locations stored in separate columns as Geography data types with the GeoLocation code. (E.G. 0xE6100000.......)
One location is the site, and the other is the nearest office.
Basically I want a new column to be added to the data which has the distance between both locations for all records - this will then be named [distance]