I am trying to work on a SQL spatial query to duplicate what you can do on Arcmap. I am basically trying to select features from one SQL table which contains parcels data(polygons), which is within 200 feet of another layer which contains streams(lines). I am using pure SQL and not ArcSDE.. I have tried to find solutions online but have not been able to find anything that works so far.
basically need features selected from parcel layer(polygons) that are within 200 feet of streams(lines)
I would greatly appreciate any help.
I am using SQL Server 2008 and spatial columns on both tables are geometry data type.