SQL - Distance to nearest premise using lat/long

Question

Hi all, I am looking to create a function that i can then use on two tables. The first with UPRN (unique premise ref.), Latitude and Longitude coordinates and type A. The second identical but of type B.

I need a function that then lists, for each UPRN in table 1, the nearest UPRNs (in order of distance) from table 2. I have looked at using the Geography type but am unsure how to build it into a function that i can then use on table 1. Can anyone please help?

ericstarker · Answer

Thanks HotCakeX!
&nbsp;
Tippelschniff175,&nbsp;&nbsp;
Hello! You've posted your question in the&nbsp;Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the SQL Server space - please post SQL Server questions here in the future.&nbsp;

hotcakex · Answer

Hi,SQL community is here:https://techcommunity.microsoft.com/t5/sql-server/ct-p/SQL-Server

ibrahimtoure20 · Answer

SVP Quelqu'un peut m aider ici comment faire un tableau dynamique croisé a partir d une base de donné sur excel

hotcakex · Answer

https://techcommunity.microsoft.com/t5/community-discussion/aidez-moi-svp/m-p/1217849

ericstarker · Answer

Ibrahimtoure20: Thanks for your question.
&nbsp;
As your question is not related to this particular inquiry (as per our code of conduct, we like to stay on topic), and you've posted your question in a separate thread, could you please monitor that thread instead to help answer your question?
&nbsp;
Appreciate that!&nbsp;

Forum Discussion

SQL - Distance to nearest premise using lat/long

Share

Resources