clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (40646 in the last week).

CREATE TABLE dbo.t ( n varchar(100) NOT NULL , i geometry NOT NULL ); INSERT INTO dbo.t (n, i) VALUES ('poly1', geometry::STGeomFromText('POLYGON ((1 2, 1 4, 1 5, 4 6, 1 2))', 4326)) , ('poly2', geometry::STGeomFromText('POLYGON ((1 2, 1 3, 2 5, 4 6, 1 2))', 4326)) , ('poly3', geometry::STGeomFromText('POLYGON ((7 9, 8 7, 9 6, 7 9))', 4326)) SELECT t1.n , t2.n FROM dbo.t t1 INNER JOIN dbo.t t2 ON t1.i.STIntersects(t2.i) = 1 WHERE t1.n < t2.n;
n n
poly1 poly2
 hidden batch(es)