I would like to win the book, I find this really useful to delete duplicate items -

create table #T (identifier int, name varchar(100))

insert into #T select 1, 'Fred'

insert into #T select 1, 'Fred'

insert into #T select 2, 'Dave';

Select * from #T;

with duplicates

as

(Select row_number() over (partition by identifier order by identifier) rn

From #T)

Delete from duplicates where rn > 1

Select * from #T;