I'm new to the spatial functionality of MS SQL Server 2008.

I have a table tblPoints with about 3000 point coorodinates and
another table tblLines with about 100000 polygon coordinates. Each
polygons is made of various numbers of line segments.

How looks the sql statement to get the nearest polygon or line segment
to each point?

TIA,
Harry B.

Harry B. (bongoplayer (AT) gmail (DOT) com) writes:
I recommend that you post your question to
http://social.msdn.microsoft.com/For...patial/threads

No matter how much like newsgroups over forum, the spatial stuff goes
completely over my head, so I can't help.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx