???3??

邦永&中国项目管理

上一篇目录下一篇

常见问题与分析

内部数据错误

排查方法:

在帐套库运行下列语句,如果不能找到记录,则说明当前登录都的部门或公司没有,其中 ey00313='1001',1001为登录名,替换这个即可。

SELECT userId=pj00401, userName=pj00402, userState=pj00412, pj00421, pj00301, pj00302, pj02501, pj02506, ey00307=ey00307  + ey00311,

 thisTime=Convert(varchar(19), GetDate(), 21), ey00312 FROM sdpj004

                            INNER JOIN sdey003 ON pj00421=ey00301

                            INNER JOIN sdpj003 ON pj00301=pj00417

                            INNER JOIN sdpj025 ON pj00311=pj02501

                            WHERE ey00313='1001'

 

 



关闭
3D?? ???3?? ??11?5 ??11?5??? ??11?5?? ???? ???3?? 3D?? ???3?? ??11?5???