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