Search results

I am creating a db to track jobs. I have a “PRIORITY” column in a “JOBS” table. What I would like to do is when a new JOB comes in I will set the PRIORITY. IF I have 10 JOBS current and a new job comes in and I set the PRIORITY to say “5” I need all the JOBS below 5 to increment by 1. Thanks for...