查询出现异常。在将 varchar 值 '40f2e9d99f958b1311e4738857f74123' 转换成数据类型 int 时失败。
SELECT * INTO TMP62C821270A8F11E5956B40F2E9D FROM (SELECT acctService.*, rankTran.FNUMBER, rankTran.fname fdetailname, rankTran.ForbidStatus, rankTran.FVALUESOURCE, rankTran.fpkid fitemid, rankTran.FFLEXNUMBER FROM TMP5CCB2AF30A8F11E5956B40F2E9D acctService LEFT OUTER JOIN TMP62C821250A8F11E5956B40F2E9D rankTransfer ON acctService.FDetailID = rankTransfer.FDetailID LEFT OUTER JOIN TMP5CCB2AF50A8F11E5956B40F2E9D rankTran ON (rankTran.fitemid = rankTransfer.fitemid AND rankTran.FFLEXNUMBER = rankTransfer.FDATAFIELDNAME)) acctservices WHERE (((acctServices.FVALUESOURCE = 'BD_Department' AND acctServices.ForbidStatus = 'A') AND (acctServices.FNUMBER >= '02.01.01')) AND (acctServices.FNUMBER <= '02.09'))
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList, Boolean needTranslate)
在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL
按部门和一个科目过滤，时间是1-5月份的
麻烦帮忙看看
谢谢
推荐阅读