#location

Generating random Latitude & Longitude pairs in the UK via SQL

I recently needed test data consisting of many locations with latitude and longitude defined. They needed to be within the UK, but also needed to be different from each other so I could calculate distances between them. I needed them in a SQL Server ...