Travelling Sales Man Problem


I have a list of qualified addresses with Longitudes and latitudes, I want to select the top 100 addresses that are closest to each other. What code can I use to achieve that?

Thank you so much,

Google "Travelling sales man problem" and you will find lots of information online. PL/SQL is an Oracle system. This forum is for Microsoft SQL Server. Someone may try to help you but this is not really an appropriate question here.

ok it doesn't have to be PL/SQL it can be either