Duplicate Values

[Compkitty]

I am doing an insert into a table and before/after I do the insert I want to run a delet on any dupes there might be in the table.. here is what i have

DELETE FROM ANI
WHERE ANIID <=
(
SELECT MAX(ANIID)
FROM ANI
WHERE ANI = ANI 
)
AND ANI = ANI

any help would be AWESOME

 

[Catadmin]

If I'm reading that code correctly, you would delete all rows in your table with the <= portion of your Where statement instead of just duplicates.

Do a Select Into from that table to set up a test table to verify your code and this code. I think your code is a bit redundant too, and would re-write your code as:

DELETE FROM ANI
WHERE ANIID <
( SELECT MAX(ANIID)
  FROM ANI )

Of course, you might want to verify this on the SQL Server Programming group forum183.

Hope that helps.




Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???