Query help

Topics: User Forum
Sep 27, 2007 at 8:58 PM
I've been putzing arond with this for a bit and can't seem to figure it out.

I want to compare a table with points in it to a table with polygons and return all the points within one of the polygons.

The hold up seems to be that the functions I've looked at take one point (not a table of points) and one polygon table. My other problem is that the point table is stored on a server that doesn't have mssqlspatial on it. I could insall it, but would rather not.

I think I can do it if I break out temporary tables, but I'd prefer not to. Then I could join the tables together and run the query on the result table.

I'll be working on it again tomorrow, maybe a fresh brain will help.
Any thoughts or hunches?