金蝶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

 

posted @ 2018-08-30 11:04  landv  阅读(470)  评论(0编辑  收藏  举报