In regards to the hierarchyid data type in SQL Server 2008, what is the solution if the parent node gets deleted?