How can I combine these two scripts? I basically don’t want to hard code the number 34 in Query 2. I want the script to take the next number of job_id. Query 1 returns 34, so Query 2 should take 35 as the job_id.
Query 1
select top 1 job_id from job order by job_id desc
Output of query 1 – 34
Query 2
insert into job (job_id, name) values (35, 'Defend them')
Advertisement
Answer
There is no need to use order by job_id desc and top 1 to get the value you want.
You need max(job_id) + 1
insert into job (job_id, name) select max(job_id) + 1, 'Defend them' from job