Here is an example. The last six digits of the GL Account number represent Region/Division. The first matrix totals the 5 series GL Accounts. The second matrix actually has a...

I posted and now I don't see it???

Thank you, I think I'm going to give this a try.
I was curious, not being as familiar with the coding, why does the update need to address the alias...

I'm not sure I'm following.  The Job and LastJob are not keys.  The primary Keys are Company and Employee
There will always be only one Employee (it can never be...

I was wondering about the Row Number or something else being needed.  That is why I couldn't get it to work at the start.  I've started reading up on the...

Could I have used a regular join and ph.EffectiveDate <= tc.DateWorked, which I also didn't think of?

Amazing!
I've never used Cross Apply.  I have to do some reading up on that.

Thank you very much for your help,

Good point. I don't see it as a Primary/Foreign key combination.  So there must be a constraint as I cannot add equipment to the history table that doesn't ready exist...

For me, I am not using the Split Function.

Normally I only use the Where 'Something' IN (@Variable). Everything is good. The using can 'Select All' or any number...

It seems to fail if:
A) I use the TS.Skill In as part of an OR or Case statement in the Where and
B) The user selects more than one skill.