关于修复用户余额归0的问题

update t1 set t1.BalanceCoin=t2.BalanceCoin
from pandausercoin t1 inner join (
SELECT * FROM (SELECT row_number() OVER (PARTITION BY UID ORDER BY CreateTime DESC) as rownum, * FROM PandaCoinPayHistory WITH(nolock) WHERE paytype<>3 and uid IN(

SELECT UID FROM PandaUserCoin


)) t WHERE t.rownum = 1 AND t.BalanceCoin<>0
) t2 on (t1.uid=t2.uid AND t1.UpdateTime>'2011-10-13')