You're going to have to be more specific.   I'm not sure what your definition really means as to what the 3rd group is calculating.    Please provide CREATE TABLE and INSERT...

Not that I'm aware of.  You'd need to be able to use Windows Explorer or the CACLS command at a command prompt (Not SQLCMD).   If you don't have the rights...

You'll probably need to look at activity for the tables referenced by the inner procedure, along with looking to see if there's blocking going on, and look at any wait...

I don't know about the units, but it appears that you need either STContains or STDistance.   If your polygon borders are inclusive of the 100 foot distance, then you'll need...

Okay, did a little work getting the table data in place on my machine, and here's what I came up with in terms of a query that accumulates the data.  ...

Two options.
1.) Take the unwanted rows out of the spreadsheet.
2.)  Let the SSIS package bring in all the columns and rows, but add a row number to each...

As to why SQL Server cursors appear to navigate a recordset, it's because within the context of the overall query, they DO go one record at a time.   However, just...

It's important to recognize exactly where that connection needs to exist.   ODBC Connections are specific to the machine on which they are configured from within the Windows Control Panel (under...