Having Trouble With EXISTS

I'm trying to delete duplicate records from a table.
The table is full of "new" records that need to be added to the database
with some user input. Since the table is populated from multiple sources,
duplicate entries can be put in. I'd like to clean those out after each "run".

Here's what I have so far, but of course, it's not right:



create table tmpKickouts (
KICK_IDINTEGER IDENTITY,
PARTCODEVARCHAR(10),
KICKOUT_REASON INTEGER
)
INSERT INTO TMPKICKOUTS ( PARTCODE, KICKOUT_REASON)
SELECT 'ABC', 1
UNION ALL
SELECT 'ABC', 1
UNION ALL
SELECT 'ABC', 2
UNION ALL
SELECT 'DEF', 2
UNION ALL
SELECT 'GHI', 1
UNION ALL
SELECT 'GHI', 1
UNION ALL
SELECT 'GHI', 1

SELECT * FROM TMPKICKOUTS TK
WHERE NOT EXISTS (
SELECT MIN(KICK_ID) AS KICK_ID, PARTCODE FROM TMPKICKOUTS
WHERE PARTCODE IN (
SELECT DISTINCT PARTCODE FROM TMPKICKOUTS
WHERE KICKOUT_REASON=1)
AND KICKOUT_REASON=1 AND TMPKICKOUTS.KICK_ID=TK.KICK_ID AND TMPKICKOUTS.PARTCODE=TK.PARTCODE
GROUP BY PARTCODE)
AND KICKOUT_REASON=1


DROP TABLE TMPKICKOUTS



In this example, I'd want to delete records 2, 6, & 7

TIA
Mark