Also, I tried using a CROSS APPLY and keep getting the error message: Aggregates on the right side of an APPLY cannot reference columns from the left side. Even using...
OK lets see if I can do this correctly. Below are the tables and some table data. Also, Mr Pletcher, thank you for posting, my data is structured a bit...