punten binnen een geometrie

select a.* from
(SELECT [ID],[X],[Y]  FROM [tabel1]) a
inner join
(SELECT GEOMETRY  FROM [tabel2]) b
on b.GEOMETRY.STContains(geometry::STGeomFromText('POINT(' + convert(varchar, a.X) + ' ' + convert(varchar, a.Y) + ')',31370)) = 1

 

Categories:

Related Article