Friday, October 27, 2017

SQL - Sometimes it is good to use cursor

This is an example of calculating distance between two coordinates.

First step is two cursors to calculate distance. two levels. Within same county, calculate distance.
Second step is one cursor to assign same Pad to coordinates within certain distance.






No comments:

Post a Comment