22,210
社区成员
发帖
与我相关
我的任务
分享
update T1 set T1.FItemID2=T2.FItemID
output deleted.*,inserted.* -- 加这行
from TempOrder T1
join (select * from(select *,rowid=count(1)over(partition by FInterID)+1-row_number()over(partition by FInterID order by (select 1)) from TEST)t) T2
on T1.FInterID=T2.FInterID and rowid=1
FEntryID FInterID FItemID2 FEntryID FInterID FItemID2
1 10 300 1 10 400
update T1 set T1.FItemID2=T2.FItemID
output deleted.*,inserted.* -- 加这行
from TempOrder T1
join TEST T2
on T1.FInterID=T2.FInterID
FEntryID FInterID FItemID2 FEntryID FInterID FItemID2
1 10 256 1 10 300