Thank you for sharing this. It was my introduction to cursors, and I was able to adapt it to keep my input table intact (by adding top(1) to another table, instead of deleting top @cnt).

Going forward, it does appear the common table expression approach linked by Nick has more promise.

All I wanted was something like 'Ignore row errors on insert'!