Here is an example of one way of deleting duplicates. There are plenty of other ways to do this.

create table #Dupes

(

IdentityValue int identity not null,

UserValue varchar(20),

AnotherValue varchar(10)

)

insert #Dupes

select 'asdf', 'Another' union all

select 'asdf', 'Another' union all

select 'asdf', 'Another' union all

select 'qwer', 'Another' union all

select 'qwer', 'Another' union all

select 'unique', 'Another' union all

select 'another', 'Another' union all

select 'another', 'Another' union all

select 'asdf', 'Another' union all

select 'qwer', 'Another'

select * from #Dupes

;with cte as

(

select IdentityValue, UserValue, AnotherValue, ROW_NUMBER() over (partition by UserValue, AnotherValue order by IdentityValue) as RowNum

from #Dupes

)

delete cte where RowNum > 1

select * from #Dupes

drop table #Dupes