Would help to see the stored procedure as well as who is creating the procedure and the permissions it is using.

Okay, apparently things aren't quite ready for me in the lab.  Just tested your code and it looks like it will give me just what I need based on the...

I could really use some help here.  Not having a lot of luck on my own or finding anything close on the internet.

You'd think he'd know more since it appears he has been working with SQL Server for at least 9 years.  Should have picked up something hanging around here that long.

Please post the DDL (CREATE TABLE statement) for the table(s) involved, sample data (INSERT INTO statements) for each table that is representative of your problem domain (and should exhibit the...

Yes, there is a SELECT as part of the INSERT.  Locks will be taken to avoid potential data changes to the data being selected.

Another one looking for free consulting: https://www.sqlservercentral.com/Forums/1890051/Cursor