Adrian_1 (2/1/2016)

---

The OP is intending that only 1 row will be deleted (because SET ROWCOUNT = 1) and therefore on the 2nd pass will not delete because there is now...

Yes, you are right. I think, for my sample it delete Andrey customer at all 🙂

If you want change order of deleting, you must set ORDER BY option in OVER clause. This option have influence on numbering order.

Daniel Matthee (1/31/2016)

---

I have not tested but just by looking at the code will it not delete both the records???

There is nothing to indicate that you just want to get...

Not really useful article.

Yes, it's beter variant. 'In' operation is very slow operation. Again, if in you have composite key in your table (for example contactname and contactoldname)? Also, database engine optimised for...