count duplicated titles

gistfile1.sql

update rp 
set rp.TitleDuplicateCount = rj.tcount
from ReportPages rp 
inner join
(
	select count(rp2.TitleHash) as tcount, rp2.TitleHash
	from ReportPages rp2
	where rp2.ProjectId = {0} and PageType = 1 and HasTitle = 1
	group by rp2.TitleHash
	having COUNT(rp2.titleHash) > 1
) rj on rp.TitleHash = rj.TitleHash
where rp.ProjectId = {0} and PageType = 1 and HasTitle = 1