Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Select analyst_brokerrep, sum(NeedApproval) as NeedApproval, sum(NotApproved) as NotApproved From ( select analyst_brokerrep, Case When [status] = 3 Then count(status) END as NeedApproval, Case When [status] = 999 Then count(status) END as NotApproved FROM tbl_Offer_1_Price INNER JOIN EnrollCustomer ON tbl_Offer_1_Price.DealCapID = EnrollCustomer.DealCapID where (status IN (3, 999)) AND (analyst_brokerrep is not null) Group By analyst_brokerrep, [status] ) as Z Group By analyst_brokerrep
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.