Hi @jed ,
May be the execution plan is from plan cache. Please try to add OPTION (RECOMPILE) in SQL server query? Adding OPTION(RECOMPILE) rebuilds the execution plan every time that your query executes. Such as below;
INSERT INTO PROP_NUMERICLIMIT (ID,PROP_RESULT,COMP_OPERATOR,THRESHOLD_TYPE,NOMINAL_VALUE,UPPER_THRESHOLD,LOWER_THRESHOLD,HIGH_LIMIT,LOW_LIMIT,UNITS,STATUS) VALUES (@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11)
OPTION (RECOMPILE)
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".