Everything you need to know about backup and disaster recovery with AWS, for FREE!
;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.