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 78Thanks,