hi there,
i have this query that inserts the values stored in the temptable back into the table with the newly associated job description...
basically what happens is that when a job description is updated, it removes the active status from that old job description and creates a new job...