Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
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
|sql server bcp "SQLState = S1000, NativeError = 0 Error = [Microsoft][SQL Native Client]Unable to open BCP host data-file"||6||81|
|SQL Express connecting form remote error 26||7||52|
|Strange msg in the SSMS pane||13||58|
|Why i am getting a star, SSMS does not show me any error. Division Error||5||33|