No really, what I am looking to do is related to duplicating a particular job for reprocessing under a different job number.
My idea (design!) is to pass a stored procedure the job number of the original along with the job number of the new job and let the stored proc 'copy' the job under the new job number. A couple of other fields will also be changed as part of the process.
I thought letting the db do the work was better than writing code to do it within an application.
in your post there is a one-to -one relationship between the INSERT fields and SELECT fields. Does this give me the ability to substitute parameters passed to the sp in place of fields selected in the SELECT statement?