Use the following code to just see what is happening:

--------------------------------------------------------

-- Actual code to prepare for an UPDATE a Select

--------------------------------------------------------

;with

A as (

select

number,

row_number() OVER(PARTITION BY tekst, number ORDER BY (SELECT NULL)) volgnr

from sb_dupli

)

select Number*100+volgnr as New_Num, * where volgnr > 1

--------------------------------------------------------

-- End Actual code to prepare for an UPDATE a Select

--------------------------------------------------------

With the CTE functions it is always very easy to substitute in the last part with a SELECT, UPDATE or DELETE statement.

The above shows alle the doubles and not the 'first' row for each combination.

But you could also specify volgnr < 4, showing only for doubles for all situations or (volgnr > 1 and volgnr<4).

Ben