Share
Report
25All of a sudden I have a couple user accounts that don't return any values in RQ.110.00.
If I log into the same machine with a different account, the F3 lookup returns a list of requisitions just fine. To troubleshoot I ran SQL profiler and saw the following differences:
For the troublesome user:
'select rqreqhdr.reqnbr,rqreqhdr.status,rqreqhdr.reqtotal,vendor.name,rqreqhdr.createdate,rqreqhdr.requstnrdept,rqreqhdr.requstnrname from rqreqhdr left outer join vendor WITH (NOLOCK) on rqreqhdr.vendid = vendor.vendid where requstnrdept like '''' and requstnr like '''' and reqnbr like ''%'' and reqcntr = ''00'' order by reqnbr desc, reqcntr desc OPTION(FAST 500)'
For a user without the problem:
'select rqreqhdr.reqnbr,rqreqhdr.status,rqreqhdr.reqtotal,vendor.name,rqreqhdr.createdate,rqreqhdr.requstnrdept,rqreqhdr.requstnrname from rqreqhdr left outer join vendor WITH (NOLOCK) on rqreqhdr.vendid = vendor.vendid where requstnrdept like ''%'' and requstnr like ''USERNAME'' and reqnbr like ''%'' and reqcntr = ''00'' and (rqreqhdr.reqnbr between '' '' and ''204807zzzz'') order by reqnbr desc, reqcntr desc OPTION(FAST 500)'
Has anyone else seen this problem?
*This post is locked for comments
All responses (
Answers (
