Sunday, 30 September 2007

TSQL: Delete duplicate rows which have the same primary key

--Delete Duplicate Rows
set rowcount 1
delete from hrerequestforapproval
where hrerequestforapprovalid=40508508

TSQL: Get Duplicate Rows Count

--Get Duplicate Row Counts
SELECT hrerequestforapprovalid, count(*)
FROM hrerequestforapproval
GROUP BY hrerequestforapprovalid
HAVING count(*) > 1