2BD3t3rM1n3d
..because my brain won't bloody remember.
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
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)