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.
UPDATE dbo.accountextensionbase SET new_ordercount = ( SELECT COUNT(SalesOrderId) FROM dbo.SalesOrder AS so, dbo.Product AS p WHERE (New_source_paid_amount <> 0) AND (DATEPART(year, so.New_source_event_date) = DATEPART(year, GETDATE())) AND (so.new_source_event_id = p.new_source_event_id) AND (p. new_include_in_rollup = '1')and(so.New_source_order_type not like 'S') and ((so.new_createdby LIKE 'W%') or (so.new_createdby LIKE 'P%')) GROUP BY AccountId )
|Microsoft Dynamics AX how can you look up past inventory items that have already shipped?||4||40|
|How to simplify my SQL statement?||14||50|
|Urgent help needed! Unable to to paste in query designer||29||38|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!