This solution worked perfectly. Thanks for your help. I definitely need to study the CROSS APPLY feature more.

Thanks for the input.

The correct count should be 5. You can do STIntersection with geography. I use it often and with alot of success. A geography is...

I figured this out. I created another polygon from lines that extend from the centroid outward in 8 directions for 3 degrees. I then create a multipolygon as...

I noticed through the sql logs that named pipes was being used instead of tcpip. I had tcpip enabled but it was giving a listener error. I found...

Was there a resolution for this? I am having the same issue. I have a linked server setup from sql server 2008 sp2 to sql server 2000 sp4....