如何不使用DISTINCT从存储过程中删除重复项

CREATE TABLE #tempTable (
    column1 datatype,
    column2 datatype,
    ...
);

INSERT INTO #tempTable
EXEC stored_procedure_name;

DELETE t1
FROM #tempTable t1
JOIN #tempTable t2 ON t1.column1 = t2.column1 AND t1.column2 = t2.column2 AND ...
WHERE t1.primary_key > t2.primary_key;

DROP TABLE #tempTable;

WITH CTE AS (
    SELECT column1, column2, ..., ROW_NUMBER() OVER (PARTITION BY column1, column2, ... ORDER BY column1) AS rn
    FROM your_table
)
DELETE FROM CTE WHERE rn > 1;

DELETE FROM your_table
WHERE (column1, column2, ...) IN (
    SELECT column1, column2, ...
    FROM your_table
    GROUP BY column1, column2, ...
    HAVING COUNT(*) > 1
);