1. Use control structures to generate a global temporary table for bucket intervals 2. Delete a customer. Use @@ERROR and @@ROWCOUNT to catch deletion errors.