This code creates a polygon and 200 points (lat/lon) and then selects the points that are inside the polygon

😎

DECLARE @POLIGON geography;

SET @POLIGON = geography::STPolyFromText('POLYGON ((5 5, 10 5, 10 10, 5 5))', 4326);

DECLARE @LLTABLE TABLE

(

POINT_ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED NOT NULL

,LAT FLOAT NULL

,LON FLOAT NULL

)

;WITH NN1(N) AS (SELECT NM.N FROM (VALUES (1),(1),(1),(1),(1),(1),(1),(1),(1),(1)) AS NM(N))

,NUMBERS(N) AS (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) FROM NN1 N1,NN1 N2, NN1 N3

ORDER BY 1 OFFSET 0 ROWS FETCH FIRST (20) ROWS ONLY)

INSERT INTO @LLTABLE (LAT,LON)

SELECT

LATN.N AS LATITUDE

,LONN.N AS LONGITUDE

FROM NUMBERS LATN, NUMBERS LONN;

SELECT

LT.POINT_ID

,LT.LAT

,LT.LON

FROM @LLTABLE LT

WHERE geography::STPointFromText(CONCAT

(

'POINT('

,CAST(LT.LON AS VARCHAR(12))

,CHAR(32)

,CAST(LT.LAT AS VARCHAR(12))

,')'

), 4326).STWithin(@POLIGON) = 1