I have a database with locations with their lat and long coordinates. The area of locations is quite small with lots of them quite near each other.
I'm using this stored procedure in my project. http://www.artfulsoftware.com/infotree/queries.php?&bw=1680#109
I'm having troubles with accuracy. I need it to return more accurate results (in metres) instead of just 0 distance.
Can it be modified so I get better results?