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.
set statistics time on set statistics io on declare @Topid_in int -- The top level we want to resolve children for select @Topid_in = 2953; with subchildren (Category_ChildID, Category_ParentID) AS ( select Category_ChildID, Category_ParentID from Category_Relationship where Category_ChildID = @Topid_in union all select Category_Relationship.Category_ChildID, Category_Relationship.Category_ParentID from Category_Relationship inner join subchildren on Category_Relationship.Category_ParentID = subchildren.Category_ParentID ) select * from subchildren
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|[Unsupported] SQL Update in CRM 2011 Database||19||58|
|SQL 2008 - Disappearing Temp Table in Stored Procedure||24||55|
|How to sort columns on a continuous form populated by resetting the recordet, as when a recordset is returned from a stored procedure?||5||42|
|SQL Server 2012 and core licensing||5||22|
Join the community of 500,000 technology professionals and ask your questions.