>>OK, here's my ever so often dumb Friday afternoon question.
>>
>>I ran the Sedna upsizing wizard to upsize a VFP database to SQL Server 2012 and it managed to create duplicate records, so I now need to delete those that are duplicates. There are only a few of them so I was going to manually do it in SSMS, but of course that won't work because there is no way to uniquely identify the record I am trying to delete.
>>
>>Any suggestions on how to do this?
>
>Did you create complete duplicates or some fields are different?
>
>You may try:
>

>;with cte as (select *, row_number() over (partition by Column1, Column2, Column3 order by Column1) as Rn
>from TableWithDups)
>
>delete from cte where Rn > 1

the entire record was duplicated (don't ask me how). I tried this:

;with cte as (select *, row_number() over (partition by nav_list, nav_item, nav_command, nav_image, nav_caption, nav_securityid, nav_active order by nav_list) as Rn
from navigator)

just to see what it returned, but I get a syntax error near ')'