>>What are the values you are testing with?
>
>
>DECLARE @CenterLat Float=47.7795
>DECLARE @CenterLon Float=-65.7191
>DECLARE @SearchDistance Float=250
>
>
>In the table, I have:
>
>47.7795,-65.7191
>47.5993,-65.6506
Borislav's query is too hard to read - mine is much simpler.
If it's not broken, fix it until it is.
My Blog