金蝶k/3 K3云之家消息查询发送是否成功SQL语句

金蝶k/3 K3云之家消息查询发送是否成功SQL语句

 

1是成功，0是还在轮询中未发送，4是发送失败


select * from ICClassMCTaskCenter  where FID=390
select * from ICClassMCTaskUser where FTaskID=390
select * into #tempUserID from (
select FUserID from ICClassMCTaskUser where FTaskID=390 and FUserID>=16384
union
select t_Group.FUserID from ICClassMCTaskUser 
inner join t_Group on t_Group.FGroupID=ICClassMCTaskUser.FUserID
where FTaskID=390)A

select * from t_CloudPassport where FUserID in (select FUserID from #tempUserID)
drop  table #tempUserID