用友U8 ERP 业务消息通知查询语句
SELECT cReceiver '姓名',COUNT(cSender) '未处理消息数量'
FROM BN_BizNotify_Log
GROUP BY cReceiver
ORDER BY COUNT(cSender)
select * from [dbo].[UA_Message] where cReceiver='0023'
delete from [dbo].[UA_Message] where cReceiver='0023'
用友U8 ERP 业务消息通知查询语句
SELECT cReceiver '姓名',COUNT(cSender) '未处理消息数量'
FROM BN_BizNotify_Log
GROUP BY cReceiver
ORDER BY COUNT(cSender)
select * from [dbo].[UA_Message] where cReceiver='0023'
delete from [dbo].[UA_Message] where cReceiver='0023'