--Get a list of the used AIDs for the specific BID

DECLARE @AIDList CURSOR FOR 

  SELECT a.AID FROM TableA a INNER JOIN TableAB ab ON ab.AID = a.AID WHERE ab.BID = @BID

 

--Loop through the keyword list, calling the StoredProc (DeleteAB) to take care of the acutal deletion

DECLARE @Current_AID int

OPEN @AIDList
FETCH NEXT FROM @AIDList INTO @Current_AID
WHILE @@FETCH_STATUS = 0
BEGIN
  exec DeleteAB @Current_AID, @BID

  FETCH NEXT FROM @AIDList INTO @Current_AID

END
CLOSE @AIDList
DEALLOCATE @AIDList

DELETE FROM TableAB WHERE BID = @BID

DELETE FROM TableA WHERE AID NOT IN(SELECT AID FROM TableAB)

public void DeleteAB(int AID, int BID)

{

  //Code to remove AB

}

 

public void DeleteAllAForB(int BID)

{

  //Foreach AID related to BID

  {

     DeleteAB(AID, BID);

  }

}