Christopher

Thank you - that is the answer 😀

I need to go and read up on the PARTITION function (I understand RANK and ROW_NUMBER). I guessed that it might need to...

KrayKnot

Thanks for the attempt, but I'm afraid your idea doesn't work because Item is in the select list but "not in the aggregate function or GROUP BY clause". Taking Item...