Have a table without a Primary Key (Identity). It has led to lots of dupes. Yet each record has something that makes it unique.
Timestamp column looks like the "best" identity coupled with Account_ID, but even the Timestamp is repeated for some columns.
Can I use ROW_COUNT + Account_ID + Timestamp to select ONE UNIQUE record ONLY and ignore the duplicate records?
Is there a better way?