- add all second tier when add a top tier - remove all second tier if remove tier - Primary Key - check duplicate value DELETE FolderGroup WHERE ID IN ( SELECT A.Id FROM FolderGroup A LEFT JOIN Folder B ON A.FolderId = B.Id WHERE B.Tier = 2 AND ParentId > 0 AND NOT EXISTS ( SELECT * from FolderGroup x LEFT JOIN Folder Y ON Y.Id = X.FolderId WHERE X.FolderId = B.ParentId and X.GroupId = A.GroupId AND Y.Tier = 1 )) delete TaskItAttr where AttrProfile = 6 delete TaskItProfile where Id = 6 --delete TaskItProfileUser where TaskItProfileId = 6