I have a procedure which insert values into a summary table. Its results come from a power select what returnns around 100K lines by run!
There are two INSERT commands from 2 diferentes SELECT because there are two differents status tables (Pass/Fail).
I have realized some sequential values are skipped and not inserted into the table, but I could not realized why. I believe it can be any performance issue but I don't know how to improve insert performance.
This stored procedure is been running each minute.