I see a few issues with the stored procedure that could attribute to the performance hit. Your tempcode variable, which you insert into your code column, doesn't match in...