I worked it out 🙂

As you suggested, it just needed a slight modification to "order by" in the below section of the code:

ROW_NUMBER() OVER (PARTITION BY Game, Team ORDER BY...

Hi,

Thank you both for attempting to solve my problem. I appreciate the help.

Thom A - The solution you have posted, returns the correct team/player combination for the first team,...

Problem solved on the large data set, i worked out I just needed to apply a clustered index to my table 🙂 Sorry.....Newbie 🙂

Thanks for your help though, easy to...

That is very similiar to the code I tried putting together initially, so it makes me feel better that there is 1 solution that was close to what I was...

That is incredible. I really appreciate your help, you have done an outstanding job with it, as a newbie there was no way I could have worked that out.