Thank you for your help. Not exactly what I was looking for but lead me to my solution. I appreciate the help.

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

Got it to work - just changed it from subtracting the score to making it a greater than statement so

m.Home_Score < m.Away_Score Then 1 else 0....

Thank you for your help...

OK tried out the code but I'm getting an error saying

Message 8115, Level 16, State 2, Line 4

Arithmetic overflow error converting expression to data type tinyint.

I don't understand as everything...

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