In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.
;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.