I'm not sure how to combine two different types of tables into one. How do I force a page break on employee? Since they are two separate tables the results...

Awesome, Cross Join with Union All worked perfect.

Thank you,

• This reply was modified 5 years, 1 month ago by  Ken at work.

Thanks but I can do the T-SQL. I'll just do that.

I'm fairly sure we haven't add anything to our SQL Server yet.  I'll look this over, but I think I need to do that first. Oops, wrong forum.

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...