在运行update语句(如下面的语句)时,我会得到一个错误,告诉我SET Account_Order = LAG([Account_Order]) OVER (ORDER BY [Account_SKey]) FROM Dim_Chart_of_AccountUPDATE my_cte
SET [Account_Order] = acc_order
当我使用TOP(1)子句时,第二个嵌套select总是返回null,但是当我删除这个子句时,它会按预期返回数据,只是返回的行比需要的多。有人看到什么能解释这件事的吗?, 101), N' ') AS DeliveryDate OR C.StatusIssue = 1)ins.DATAAREAID = id.DATAAREAID
AND ins.INVENTSERIA