Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
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
|stored procedures times out after 2 hours in sql server 2014||16||36|
|SQL View nearest date||5||36|
|Setting Macro in Access to Automate Running an Append at a Certain Time||2||22|