Hello,

I had read all responses, and I have to recognise that Barry's approach, is very interesting, and clever solution...

I have test the sql-steps but i found is a little...

Hi.

One of solutions I apply in these cases is.

1. alter table and create a new identity column..

2. Make a select group by items, and get min(identity),

3. delete all records in...