关于#Update结合SELECT#的问题，如何解决？

Question

UPDATE Purch_Pay SET SN = Table1.row_number
    FROM    (SELECT TOP 100 PERCENT row_number()over (ORDER BY PayDate) row_number,PayDate,VendorID,PurchID,PayMoney,Note_number     FROM Purch_Pay ORDER BY PayDate) Table1
    WHERE  Table1.VendorID = Purch_Pay.VendorID   AND Table1.PayDate = Purch_Pay.PayDate   AND  Table1.PurchID = Purch_Pay.PurchID   AND Table1.PayMoney = Purch_Pay.PayMoney   AND Table1.Note_number = Purch_Pay.Note_number;

Answer 1

加点缩进啊，都写一起了

WITH CTE AS (
    SELECT 
        row_number() OVER (ORDER BY PayDate) AS row_number,
        PayDate,
        VendorID,
        PurchID,
        PayMoney,
        Note_number
    FROM Purch_Pay
)
UPDATE p
SET p.SN = c.row_number
FROM Purch_Pay p
JOIN CTE c ON c.VendorID = p.VendorID
    AND c.PayDate = p.PayDate
    AND c.PurchID = p.PurchID
    AND c.PayMoney = p.PayMoney
    AND c.Note_number = p.Note_number;