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 RIGHT('00' + CAST(a.ARCD11 AS varchar(2)), 2) + '-' + RIGHT('00000' + CAST(a.RCNO11 AS varchar(5)), 5) AS AMS_Ref , b.CustomerNumber FROM dbo.SON_Archive4Sentinel_PTP11 AS a LEFT OUTER JOIN ANCHORSERV.S3CUSTDB.dbo.CustomerTable AS b ON SUBSTRING(AMS_Ref, 1, 8) = b.CustomerNumber WHERE (a.EVNO11 = 50)
|install report service in sccm2012||3||19|
|Requesting help with creating an SQL query to select similar records||4||15|
|question about results where i dont have a match||3||23|
|MS SQL Delete Duplicate Rows Only||2||20|