insert into REINSCRIPT select 2015,ID,null,'OUI',1 from CPTCOOP where DATINS > '2014-11-01' and ID not in (select CPTID from REINSCRIPT)