- Mark the child (Folder B) as deleted, where a parent has been deleted:
SET c.Deleted = 1
FROM dbo.SiteFolders p, dbo.siteFolders c
WHERE c.ParentFolderID = p.FolderID
AND c.Deleted = 0
AND p.Deleted = 1
- Unmark the parent (Folder A) as deleted, where there is an undeleted child folder:
UPDATE p
SET p.Deleted = 0
FROM dbo.SiteFolders p, dbo.siteFolders c
WHERE c.ParentFolderID = p.FolderID
AND c.Deleted = 0
AND p.Deleted = 1