Hi All:

I can't figure out the SQL needed for this problem. There cannot be 2 records with the same location. Therefore Item# 6677 is invalid:

Item#      Location
1234       LOC1
2345       LOC1
2345       LOC2
6677       LOC1
6677       LOC1

I need the SQL to generate the following cursor, containing all the invalid records, appending the recno():

Item#   Location   Recno
6677    LOC1       43
6677    LOC1       78

Thanks,

Yossi