Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
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
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!