I tried your code, I love it because it is so simple but you're giving me credit for being smarter than I am so thank you for that. The job_id column is an identity and this is what I tried:
INSERT INTO dbo.jobs (job_desc,min_lvl,max_lvl)
SELECT job_id = Null, job_desc = 'Big Pest', min_lvl,max_lvl
WHERE job_id = 14;
This was the error message:
Msg 121, Level 15, State 1, Line 1
The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns.
I deleted the two columns I wasn't changing from the select statement and that didn't work either so I am still very, very lost.
thanks for the help and for responding,
michael