distance.sql

declare @p geography = geography::Point(10.5, 10.5, 4326);

SELECT * 
FROM (
    select Plant_ID,Plant_GeoLocation.STIsValid() as IsSTValid, Plant_GeoLocation.MakeValid().RingN(1).STDistance(@p) as Distance, Plant_GeoLocation as Geolocation from dbo.tb_opr_Plant 
        WHERE Plant_GeoLocation IS NOT NULL AND Plant_GeoLocation.STIsValid() = 1 
) DistanceMeastureFromPoint
WHERE Distance < 1000