Nice script. The "ctrl+shift+m - thing" was new for me and it's a very intresting feature.

But .. if you 've added these defined variables instead of the numbers in your...

I do use it in production environmentbecause of getting date from other Systems that conteins duplicatetd data (don't ask ....) and it works fine.

In the past i've worked on Oracle...

My faforite method to clean-up duplicated rows is this (I used the example code from above):

CREATE TABLE Duplicates(

CustID INT,

Col1 INT,

...