Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery
;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
|combining condition to rerun if failure within BEGIN..END||27||87|
|BULK LOGGED - log full||9||25|
|Help with stripping out character in SQL LEFT/RIGHT/REPLACE||2||42|
|Unable to save view in SSMS||21||61|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!