Good afternoon, I have the following process:
1. Data stored in a temporary table
2. I have a sp that reads information from the temporary table and records in other tables, the problem is that not all records are processed. For example: I have 1000 records and there is an error in the log 501 and 502, then the record just inserted to the 500 and the process is canceled.
As I can do? for though no errors insert all records that are missing, ie continue with registration 503, 504, etc.
Below is the sp