KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am using geography.STDistance() to return the distance between two single point locations. I'm curious as to which measurement is used for the return value? Is it in KM's, miles or perhaps some other? I'm getting results back upwards of 250k but i've no idea if im doing something wrong with my TSQL as these are historical locations(i.e. they no longer exist) so I can't just do a quick lookup. declare @p1 geography declare @p2 geography SELECT @p1 = Location from tblLocations where Id = 1 SELECT @p2 = Location from tblLocations where Id = 2 select @p1.STDistance(@p2)
Tags (comma-separated)
Save Edits
Cancel