It is worth noting that the Date applies to the Created Date and not the Modified Date

!

Nikos, you have a Policy Header record and 5 Policy Detail records, presumably each detail record contains different information (e.g. items covered, bike, car, house, tv, phone)
if you only...

Personally I prefer

WITH cte AS (

SELECT a.*,

ROW_NUMBER() OVER(PARTITION BY field1,field2 ORDER BY field1,field2) rrn

FROM dbo.file_with_duplicates a)

DELETE FROM cte WHERE rrn > 1

but it won't tidy up triplicates....

The OP is intending that only 1 row will be deleted (because SET ROWCOUNT = 1) and therefore on the 2nd pass will not delete because there is now only...

according to MSDN, "Using SET ROWCOUNT will not affect DELETE, INSERT, and UPDATE statements in a future release of SQL Server. Avoid using SET ROWCOUNT with DELETE, INSERT, and UPDATE...

it's working fine now, dunno what happened the previous time 🙂

Thanks for the help

Hi Steve

This sounds like a really useful tip, but what should I look for if it doesn't work?

Ctrl/F12 does absolutely nothing, yes I do have SQL Prompt installed and it...