Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.
;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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.