Hi Jeff,

Thanks for the reply. I dont understand what you mean. I thought the first part of the correlated subquery gave me what I was looking for in setting the...

Thanks very much. That worked a treat. I modified the final SELECT to aggregate, as it is easier to read.

SELECT colA, MAX(colB) FROM CTE GROUP BY colA

Thanks again!