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

网名：浩秦;

邮箱：root#landv.pw;

只要我能控制一個國家的貨幣發行，我不在乎誰制定法律。金錢一旦作響，壞話隨之戛然而止。