我有一个从SP获取值的表。我想知道一组数据是否反向重复

CREATE PROCEDURE CheckReverseDuplicateData
AS
BEGIN
    -- 获取数据
    SELECT Column1, Column2, ... INTO #TempTable FROM YourTable;

    -- 反向排序
    SELECT Column1, Column2, ...
    FROM #TempTable
    ORDER BY Column1 DESC, Column2 DESC, ...;

    -- 判断重复
    IF EXISTS (
        SELECT *
        FROM #TempTable
        INTERSECT
        SELECT Column1, Column2, ...
        FROM YourTable
    )
    BEGIN
        PRINT '数据存在反向重复';
    END
    ELSE
    BEGIN
        PRINT '数据不存在反向重复';
    END

    -- 清理临时表
    DROP TABLE #TempTable;
END