select count(*) as totalRequests
from tbl_TPM_RequestApprovers ra
inner join tbl_TPM_Requests req
on req.requestid = ra.requestid
where ra.ownerid =
and ra.ownertype =
and ra.approverUserId =
and ra.approverRole = 'APPROVER'
and ra.status =
ALERTS
-
#qryTradeRequests.totalRequests# Trade Requests to Review
-
3 Contracts Expiring in 30 Days