SELECT `JOB_NO` - 1 FROM `nxtjobno` INTO @job_no;
 
INSERT INTO `repairs`
(
	`created`, `JOB_NO`, `SPI_TAKING`, `CALL_DATE`, `CALL_TIME`,
	`CONT_YEAR`, `CALL_TYPE`, `JOB_FUEL`, `CUST_ORDNO`, `CALL_NAME`,
	`HOUSE_KEY`, `CALL_REMS`
) SELECT
	NOW(), LPAD((SELECT @job_no := @job_no + 1), 6, '0'),
	'IMPORT', CURDATE(), CURTIME(), 5, 'PM', 'G',
	`works_order`, 'DECEMBER 09', `asset_no`, 'SERVICE YR5'
FROM `december09`;