Does anyone want to help me take a crack at this?

To calculate the 'Mandatory Complete' column in the resultset, I wrote the following to generate dynamic SQL using cursors, but...

I just can't seem to get it right, can I? Thank you for your work; my experience with SQL does not go much beyond 'SELECT... FROM'. I simply tried to...

Sorry again, re-updating the original post. 🙂 I apologize in advance for any mistakes, but I don't think there are any.

I have updated the top post to add some sample data. Thanks guys.

I have deobfuscated the links, is this good enough? If not, I can change them.