Fjerne dubletter i en tabel

Hejsa

Jeg har fået en større fil der nu er importeret i MSSQL 2000. Problemet er, at ham der har lavet filen ikke har tjekket for dubletter. Nu er tabellen taget i brug og vi skal have lavet en nøgle på tabellen - og det kan jeg jo ikke.

Jeg prøver så med følgende script, fundet hos MS, og rettet til men det virker ikke :-( Er der en der kan lure hvad der er galt?

SELECT  CoverCharge_Code, CoverCharge_Symp_Code, CoverCharge_CalT_Code, CoverCharge_Cont_Num, col3= count(*)
INTO holdkey
FROM SCCoverCharge
GROUP BY CoverCharge_Code, CoverCharge_Symp_Code, CoverCharge_CalT_Code, CoverCharge_Cont_Num
HAVING count(*) > 1


SELECT DISTINCT SCCoverCharge.*
INTO holddups
FROM SCCoverCharge, holdkey
WHERE SCCoverCharge.CoverCharge_Code = holdkey.CoverCharge_Code
AND SCCoverCharge.CoverCharge_Symp_Code = holdkey.CoverCharge_Symp_Code
AND SCCoverCharge.CoverCharge_CalT_Code = holdkey.CoverCharge_CalT_Code
AND SCCoverCharge.CoverCharge_Cont_Num = holdkey.CoverCharge_Cont_Num


DELETE SCCoverCharge
FROM SCCoverCharge, holdkey
WHERE SCCoverCharge.CoverCharge_Code = holdkey.CoverCharge_Code
AND SCCoverCharge.CoverCharge_Symp_Code = holdkey.CoverCharge_Symp_Code
AND SCCoverCharge.CoverCharge_CalT_Code = holdkey.CoverCharge_CalT_Code
AND SCCoverCharge.CoverCharge_Cont_Num = holdkey.CoverCharge_Cont_Num
AND SCCoverCharge.CoverCharge_ProdFamily_Code  = holdkey.CoverCharge_ProdFamily_Code


INSERT SCCoverCharge SELECT * FROM holddups