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.
;WITH cte (name, CatalogID, parentcatalogid) AS ( select CI.[Name], CI.CatalogID, NULL as ParentCatalogID from [CatalogInfo] CI union all select convert(varchar(max),cte.name+' | '+ (COALESCE(C.[Name], CLc.[Name]))) , C.catalogid, C.parentcatalogid from [Catalog] as C LEFT join CatalogLC CLc ON CLc.CatalogID = C.CatalogID AND CLc.LCID = 1033 inner join cte on C.parentcatalogid=cte.[catalogid] ) SELECT cte.CatalogID, cte.name from cte
|How to pass a parameter to limit the colums returned in Stored Procedure SQL 2016||2||35|
|When I execute a stored proc with input parms using SQL Server 2008, I get the following error msg: Msg 8152 String or binary data would be truncated. Do you know how I can resolve this?||1||22|
|How do I subtract date and time within a same column in SQL||4||38|
|SSRS 2013 - Creating a summarized report||19||35|