We would have an identity column so wouldn't need to be using RowNumber in the query. Also we would have a unique natural key to not allow duplicates in the first place. But thanks for the interesting read.