A more efficient way of coding this is to perform the deletion and then check @@ROWCOUNT afterwards, thus hitting the table once per deletion rather than twice.