u821工资部份人员计算不出工资项

问题现象:工资变动，公式正确的情况下，同类人员有部份工资计算不出来

问题原因:U821中允许人员编码重复使用，而升级后872是不允许重复编码的,存在重复记录后，计算公式计算不出来

解决方案:

SELECT * Into pSn FROM (SELECT cGZGradeNum, cPsn Num, MAX(dInTme) AS Expr1 FROM WA PSnGROUP BY cGZGradeNum, cPsn_Num) DERIVEDTBL-.取出最新增加人员 select wa_psn.* into bak from wa_psn,psnwhere wa psn.cGZGradeNum = psn.cGZGradeNum and wa, psn.cPsn, Num =psn.cPsn Num and dintime = psn.exprl