Clean duplicate cmsLanguageText if duplication occurs.

readme.md

Crates a delete queries, so you can easily clean duplicate entries.. If you ware medeling with the cmsLanguageText.

Just for reference.

cmsLanguageText.sql

with c (UniqueId) as 
(
select UniqueId from  cmsLanguageText
group by UniqueId
having count(1) > 2
)
select 
'delete from cmsLanguageText where UniqueId = ''' +cast( l.UniqueId as varchar(max)) + ''' and pk != '+cast( min(l.pk) as varchar(max)) +' and languageId = '+ cast(l.languageId as varchar(max)) +';',
l.UniqueId, l.value,l.languageId, min(l.pk) as pk, count(1) as Count
 from cmsLanguageText l
inner join c
on c.UniqueId = l.UniqueId
group by l.UniqueId, l.value, l.languageId
order by l.UniqueId
go