SQL Server - Borrar Duplicados

SELECT , MPrecios.IdLinea, MPrecios.IdItinerario, MPrecios.IdOrigen, MPrecios.IdDestino, MPrecios.IdProducto

FROM MPrecios

INNER JOIN MLineas ON MLineas.IdLinea = MPrecios.IdLinea

INNER JOIN MParadas AS pOrig ON pOrig.IdParada = MPrecios.IdOrigen INNER JOIN MParadas AS pDest ON pDest.IdParada = MPrecios.IdDestino

INNER JOIN MItinerarios on MItinerarios.IdItinerario = MPrecios.IdItinerario INNER JOIN MProductos ON MProductos.IdProducto = MPrecios.IdProducto

WHERE MPrecios.Borrado = 0 AND MPrecios.IdRegActivo IS NULL AND FechaValidoIni <= GETDATE() AND(FechaValidoFin IS NULL OR FechaValidoFin > GETDATE()) AND MPrecios.Prohibido = 0  AND MPrecios.IdLinea = 1994

DELETE A

FROM MyTable A

INNER JOIN

(

        SELECT ROW_NUMBER()OVER(PARTITION BY a.col1,

        a.Col2

        ORDER BY a.Col1,a.Col2)AS POS,

        a.rowID,

        a.Col3

        FROM MyTable A

        JOIN

        (

            Select

            Col1,

            Col2,

            COUNT(*) AS CONTADOR

            from MyTable

            group by Col1,

            Col2

            HAVING COUNT(*) > 1

        ) TB

        ON A.col1 = TB.col1

        AND A.col2 = TB.col2

) TB_2

ON

a.ROWID = tb_2.ROWID

and tb_2.pos > 1

CREATE TABLE #temp

(

code int,

iencucod int,

duracion int

)

INSERT INTO #temp values (1,2999,1062)

INSERT INTO #temp values (1,2999,1062)

INSERT INTO #temp values (1,2999,1062)

INSERT INTO #temp values (1,2999,1062)

INSERT INTO #temp values (1,2999,1062)

INSERT INTO #temp values (1,2999,1062)

INSERT INTO #temp values (2,2999,610)

INSERT INTO #temp values (3,2999,34)

INSERT INTO #temp values (4,6170,447)

INSERT INTO #temp values (5,15729,1148)

INSERT INTO #temp values (6,15729,241)

INSERT INTO #temp values (6,15729,241)

INSERT INTO #temp values (6,15729,241)

INSERT INTO #temp values (7,15729,53)

INSERT INTO #temp values (8,38314,1029)

INSERT INTO #temp values (8,38314,1029)

INSERT INTO #temp values (8,38314,1029)

INSERT INTO #temp values (9,38314,256)

select * from #temp

WITH CTE (code, iencucod, duracion, DuplicateCount)

AS

(

SELECT code,iencucod, duracion,

ROW_NUMBER() OVER(PARTITION BY code, iencucod, duracion ORDER BY code,iencucod, duracion) AS DuplicateCount

FROM #temp

)

DELETE

FROM CTE

WHERE DuplicateCount > 1

GO