How to delete records on MDS using SQL code?

Question

I am trying to delete records on MDS using the staging table, and although I already updated the records to the ImportType 4 (Delete record):

On MDS it appears not only the correct line (Code 29355) but also the other ones that should have been deleted:

Answer 1

Solution found:

Instead of updating only the ImportType value in Leaf Staging Table with 4 the ImportStatus_ID must also be updated to 0.

! Be careful: one of the errors raised was related with deleting members that had already been deleted --> To correct this, it was added to the update statement referred above the condition of only updating to (ImportType = 4, ImportStatus_ID = 0) the records that have the ImportType = 0 (new members).