INdexes is definitely a MUST thing here or everywhere .
other thing can below will return the same data too ?
;WITH e_Dupe AS
(
SELECT mcrn
,mpidm
FROM Registration_loaderr
WHERE error_check = '142285'
GROUP BY mcrn, mpidm
HAVING COUNT(*) > 1
)
SELECT *
FROM Registration_loaderr le
INNER JOIN e_Dupe ed
ON le.mcrn = ed.mcrn
AND le.mpidm = ed.mpidm
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)