create table nameoftable (AutogeneratedIdColName int identity(1,1) , restof columns of your table)
update tablename set passwordcolumn=passwordcolumn+ cast(uridentycolumn as varchar(10)) where passwordcolumn in ( select passwordcolumn from tablename group by passwordcolumn having count(*) > 1 )
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)