April 13, 2022 at 6:52 am
Hi ,
I do have source coordinates and distance to destination in meters .I need to calculate the Destination Coordinates and orientation .Could some one help me with the formula in SQL . Thanks in Advance.
April 13, 2022 at 7:11 am
How does knowing the distance from source allow you to calculate the destination? Wouldn't you also need to know the exact direction?
If you want people to write SQL, please provide DDL, sample data and desired results, as usual.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
April 13, 2022 at 2:40 pm
Without either the destination location or at least it's orientation, all you're looking at initially is a query within a radius. You can use STWithin to identify any other points within a radius. Then, run the calculation on location & direction for any points that match.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply