DECLARE @latitude DECIMAL(18, 12);
DECLARE @longitude DECIMAL(18, 12);

SET @latitude = 34.760623;
SET @longitude = 113.632004;

DECLARE @checkCount INT;
DECLARE @step BIGINT;
DECLARE @whileCount INT;

SET @step = 10;
SET @checkCount = 0;
SET @whileCount = 0;

DECLARE @needReset BIT;
SET @needReset = 1;

WHILE ( @needReset = 1 )
    BEGIN
        SET @checkCount = 0;
        SELECT  @checkCount = COUNT(1)
        FROM    se.Secretaries
        WHERE   1 = 1
                AND GeoHashLong BETWEEN 4063912279765413 - @step
                                AND     4063912279765413 + @step;

        IF ISNULL(@checkCount, 0) < 30
            BEGIN
                SET @step = @step + @step;
                SET @whileCount = @whileCount + 1;
            END;
        ELSE
            BEGIN
                SET @needReset = 0;
            END;

        IF @whileCount > 30
            BEGIN
                SET @needReset = 0;
            END;
    END;

SELECT @whileCount
SELECT  @step;

SELECT  Id ,
        GeoHash ,
        GeoHashLong ,
        POWER([Latitude] - @latitude, 2) + POWER([Longitude] - @longitude, 2) AS vDistance
FROM    se.Secretaries
WHERE   1 = 1
        --AND GeoHash LIKE 'ww0v9zb%'
        AND GeoHashLong BETWEEN 4063912279765413 - @step
                        AND     4063912279765413 + @step
ORDER BY vDistance;