Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
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
|How to automate & schedule this Index optimization Script ?||10||66|
|SQL Select * from||6||30|
|Get row count of current SQL query||8||36|
|Sql Query join multiple table and distinct records||7||26|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!