Yes, I can see that would be a solution, but that would mean I have to make those 2 tables in code. Data is always supplied in the format of the posted simplified table. I was hoping I could get the column rank with a window function or a CTE. RBS
Yes, I can see that would be a solution, but that would mean I have to make those 2 tables in code. Data is always supplied in the format of the posted simplified table. I was hoping I could get the column rank with a window function or a CTE. RBS