SQL Server :: Trying To Handle Update And Inserting Within A Procedure?

We have a page where you can insert a record. On the page we have validation to prevent duplicate IP addresses from being submitted for the same location. Now on the procedure side i have a condition that is checked, if you supply data that already exists for a location, then it will be updated. If its not then its inserted.. this all works fine.. issue now that i noticed is that we have a table that is part of the process, if you select say 3 from a drop down for number of emails, then when you submit the page, i have a loop for each of those emails and they are inserted into the email table as individual records.. works great also.. BUT here is my problem.. if i submit say an existing set of data and this time i provide say 1 email vs 3 from the previous time, i need to handle that in the procedure, so that the 3 are deleted and only 1 is now inserted and linked to that record..

Hope this makes sense..

Since im doing a foreach loop based on that dropdown selection, now when i look at my table im getting only 1 record in the email table... since the logic is within the procedure, when the page calls the procedure, it finds tha the record exists, deletes all the records, then only inserts the last record.

Example.

I submit the page with 3 emails today.. everything works and goes in as expected, there are 3 emails and record is created without issues..

Tomorrow someone else comes in from my team and decides to enter the same record data, thats not a problem, because there is an update statement if it already exists.. BUT this time they entered only 2 emails.. the 2 new emails are inserted / updated in the table, but the 3rd email is still in there.. its not removed.. so i tried to add a if exists condition to my procedure, but since the procedure is called in my foreach loop, the first loop sees the records, deletes them and inserts the first email, then on the 2nd foreach loop it deletes that last entry and inserts the next, so by the time it goes thru it has deleted everything it inserted and only captures the last record..

Just tried it now.. and since there was already 1 record in the table, i chose to add 4.. the end result should be 4, but i now have 5 records in there.. the first one and the 4 new ones..