Try this.  I don't have your complete data set so I don't exactly know what the performance will be but these types of things can be amazingly quick.  Don't sweat...

I'm getting ready to submit a dual...

😀

I won't be interviewing any avatars.  My personal opinion is that they'd be even worse than phone interviews.  You know the ones I'm talking about... the ones where you ask...

Also, help us help you when we finally determine what you're actually asking.  Please see the article at the first link under "Helpful Links" in my signature line below.  Thanks.

I grok your question. 

First, you've been around long enough for you to start helping the people that you want help from.  Please read and heed the article...

To me, regurgitating the actual code as a diagram is very nearly useless, especially in SQL Server.  And, to me, creating any diagram without documenting in the code itself is...

I've not tested it because I'm on my way to work but I believe this will get you to where you want to be with the character based Supply Job...

Hmmm.... is there an integer column on the original supply job table that acts like a surrogate key for the Supply Job Number?