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.
DECLARE @NumberPortion int SET @NumberPortion = ???? RETURN CASE WHEN (@NumberPortion BETWEEN 1 AND 99) AND Field2 < 12 THEN 0 WHEN (@NumberPortion BETWEEN 100 AND 199) AND Field2 < 8 THEN 0 WHEN (@NumberPortion >= 200) AND Field2 < 4 THEN 0 ELSE 1.5 END
|SQL Server - Date Calc for 1st Day of Current Month for LAST YEAR?||3||46|
|SQL Server 2012 rs - Sum each category by month||4||40|
|Addition to SQL for dynamic fields||6||47|
|SSRS - Dropdown with Null||3||28|