Hi Piet

Thanks for guiding me. I've didn't even know about CTE before I started this topic. I'm trying to learn it but its just out of my grasp at the moment.

Could you do me a massive favour and convert your code to insert the output into a table. I've realised that I need to run this job out of hours :-

WITH MyDupesRN AS

(

SELECT *

, ROW_NUMBER() OVER (PARTITION BY SomeDate, NumValue ORDER BY SomeDate, NumValue) AS rn

FROM #Test

)

SELECT SomeDate, NumValue, rn

FROM MyDupesRN

WHERE rn=1;

Kind Regards

James