是这样的,我在上一个菜单里面查这个为'807230200004969'这个账户,状态是“账户印鉴更新暂存退出”,可是在账户状态里面查询,就显示不出来这个账户,于是我用SQL追踪,得出了以下语句:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 120000;SET XACT_ABORT ON ;
insert into seallog (clerkid,departid,operate,operatetime,re)
select '1111111' As Clerkid ,DepartId,311 As operate,GetDate(),'' As re from SealClerk
where clerkID = '1111111' and (Isdelete = 0 or Isdelete is Null)
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 120000; SET XACT_ABORT ON ;
select a.ActNo,a.Status,a.FrmSFTP,b.ClerkID as OpClerkID,c.OpenBank as OpDepartID,
b.OperateTime as OpDate from ActIndex as a,SealLog as b,SealAct as c
where a.Status=7 and a.indexno=0 and a.ActNo=b.ActNo and b.Operate=1501 And b.OperateTime>='2011-05-18 00:00:00'
And b.OperateTime<='2011-05-18 23:59:59' and a.ActNo=c.ActNo and a.ActInfoID=c.ActInfoID请达人们帮我看下,谢谢~为什么这个807230200004969的账户在状态里面显示不出来,
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 120000;SET XACT_ABORT ON ;
insert into seallog (clerkid,departid,operate,operatetime,re)
select '1111111' As Clerkid ,DepartId,311 As operate,GetDate(),'' As re from SealClerk
where clerkID = '1111111' and (Isdelete = 0 or Isdelete is Null)
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 120000; SET XACT_ABORT ON ;
select a.ActNo,a.Status,a.FrmSFTP,b.ClerkID as OpClerkID,c.OpenBank as OpDepartID,
b.OperateTime as OpDate from ActIndex as a,SealLog as b,SealAct as c
where a.Status=7 and a.indexno=0 and a.ActNo=b.ActNo and b.Operate=1501 And b.OperateTime>='2011-05-18 00:00:00'
And b.OperateTime<='2011-05-18 23:59:59' and a.ActNo=c.ActNo and a.ActInfoID=c.ActInfoID请达人们帮我看下,谢谢~为什么这个807230200004969的账户在状态里面显示不出来,
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 120000; SET XACT_ABORT ON;SELECT
a.ActNo, a.Status, a.FrmSFTP, b.ClerkID AS OpClerkID, c.OpenBank AS OpDepartID,
b.OperateTime AS OpDate
FROM ActIndex a
INNER JOIN SealLog b ON a.ActNo = b.ActNo
INNER JOIN SealAct c ON a.ActNo = c.ActNo AND a.ActInfoID = c.ActInfoID
WHERE
a.Status = 7 AND a.indexno = 0 AND
b.Operate = 1501 AND
b.OperateTime BETWEEN '2011-05-18' AND '2011-05-19'
1、807230200004969 账户的 ClerkID = '1111111'?
2、先去掉几个筛选条件 再逐个加上 看返回的记录
3、感觉查询应该以 SealLog 为主将查询改成这样试试SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 120000; SET XACT_ABORT ON;SELECT
b.ActNo, b.ClerkID AS OpClerkID, a.Status, a.FrmSFTP, c.OpenBank AS OpDepartID,
b.OperateTime AS OpDate
FROM SealLog AS b
LEFT OUTER JOIN ActIndex AS a ON b.ActNo = a.ActNo
LEFT OUTER JOIN SealAct AS c ON c.ActNo = a.ActNo AND c.ActInfoID = a.ActInfoID
WHERE
a.Status = 7 AND a.indexno = 0 AND
b.Operate = 1501 AND
b.OperateTime BETWEEN '2011-05-18' AND '2011-05-19'
高手果然出现了,我感觉还和ActIndex表有关系,
'1111111'是登陆时候用的账号,所以就是ClerkID ='1111111'