I need to identify duplicate records based on unique ID number and assign a value 1 to the first occurance and 0 to the rest. Here is an example: ID Assign 01 1 01 0 01 0 02 1 02 0 02 0 02 0 Thank you, Helal