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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply