plz help me I stake here. currenly I am working in sql -2000

SELECT IDENTITY(int,1,1)  AS row_num,PerformanceDate, Score ,Category ,Reason ,UserName,Event_Date
 into #temptable
  FROM tbl_Temp

SELECT
    [current].PerformanceDate,[current].Score ,[current].Category ,[current].Reason ,[current].UserName,[current].Event_Date,row_num
FROM
    #temptable AS [current]
LEFT OUTER JOIN
    #temptable AS previous
    ON [current].PerformanceDate = previous.PerformanceDate
    AND [current].Score = previous.Score
    AND [current].Category = previous.Category
    AND [current].Reason = previous.Reason
    AND [current].UserName = previous.UserName
      AND [current].Event_Date = previous.Event_Date
    AND [current].row_num = previous.row_num + 1
WHERE
    [current].PerformanceDate = previous.PerformanceDate
    AND [current].Score <> previous.Score
    AND [current].Category <>previous.Category
    AND [current].Reason <> previous.Reason
    AND [current].UserName <>previous.UserName
      AND [current].Event_Date <>previous.Event_Date
ORDER BY
    [current].PerformanceDate

WITH CTE_TEST AS
(
    SELECT PerformanceDate, Score ,Category ,Reason ,UserName,Event_Date,
           ROW_NUMBER() OVER (PARTITION BY PerformanceDate, Score ,Category ,Reason ,UserName,Event_Date ORDER BY PerformanceDate) AS row_num
    FROM tbl_Temp
)
SELECT
    [current].PerformanceDate,[current].Score ,[current].Category ,[current].Reason ,[current].UserName,[current].Event_Date,
FROM
    CTE_TEST AS [current]
LEFT OUTER JOIN
    CTE_TEST AS previous
    ON [current].PerformanceDate = previous.PerformanceDate
    AND [current].Score = previous.Score
    AND [current].Category = previous.Category
    AND [current].Reason = previous.Reason
    AND [current].UserName = previous.UserName
      AND [current].Event_Date = previous.Event_Date
    AND [current].row_num = previous.row_num + 1
WHERE
    [current].PerformanceDate = previous.PerformanceDate
    AND [current].Score <> previous.Score
    AND [current].Category <>previous.Category
    AND [current].Reason <> previous.Reason
    AND [current].UserName <>previous.UserName
      AND [current].Event_Date <>previous.Event_Date
ORDER BY
    [current].PerformanceDate