how about if you join the fields?

Try this:

WITH CTE (emppin,trxdate, trxtime, DuplicateCount)

AS

(

SELECT emppin,trxdate, trxtime,

ROW_NUMBER() OVER(PARTITION BY emppin,trxdate, trxtime ORDER BY emppin) AS DuplicateCount

FROM dbo.rawtrx

)

DELETE

FROM CTE

WHERE DuplicateCount > 1

you need to replace the fields etc

this however deletes the duplicates... im really not much of a bottle feeder so you need to do the modifications.