Travelling Sales Man Problem

1

Hi,

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,

2

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.

3

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