| 解决方案： |
在sql的查询分析器中执行下列语句，所查询出来的结果既是没有审核的单据。
select * from DispatchList
where rtrim(ltrim(IsNull(cVerifier,‘‘)))=‘‘ And (dDate <=‘2001-12-31‘)
select * from EnDispatch
where rtrim(ltrim(IsNull(cVerifier,‘‘)))=‘‘ And (dDate <=‘2001-12-31‘)
select * from EnDispatch
where rtrim(ltrim(IsNull(cVerifier,‘‘)))=‘‘ And bFirst=1
select * from SaleBillVouch
where rtrim(ltrim(IsNull(cInvalider,‘‘)))=‘‘
And rtrim(ltrim(IsNull(cChecker,‘‘)))=‘‘ And IsNull(cSTCode,‘‘)<>‘‘
And IsNull(bFirst,0)=0 And (dDate <=‘2001-12-31‘)
select * from ExpenseVouch
where rtrim(ltrim(IsNull(cVerifier,‘‘)))=‘‘ And (dDate <=‘2001-12-31‘) |