1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| insert into DISTRITEC2.dbo.RETENUESALAIRE
(DISTRITEC2.dbo.PRE_SALARIE,DISTRITEC2.dbo.PRE_ORDRE,DISTRITEC2.dbo.PRE_LIBELLE,DISTRITEC2.dbo.PRE_DATEDEBUT,DISTRITEC2.dbo.PRE_DATEFIN,
DISTRITEC2.dbo.PRE_MONTANTMENS,DISTRITEC2.dbo.PRE_MONTANTTOT,DISTRITEC2.dbo.PRE_NBMOIS,DISTRITEC2.dbo.PRE_nbjours,DISTRITEC2.dbo.PRE_SOLDE,
DISTRITEC2.dbo.PRE_ACTIF,DISTRITEC2.dbo.PRE_RIB,DISTRITEC2.dbo.PRE_RETENUESAL,DISTRITEC2.dbo.PRE_TYPEPAIERET,DISTRITEC2.dbo.PRE_RUBRIQUE,
DISTRITEC2.dbo.PRE_BENEFICIAIRERS,DISTRITEC2.dbo.PRE_NIVEAURS,DISTRITEC2.dbo.PRE_DATECREATION,DISTRITEC2.dbo.PRE_DATEMODIF,
DISTRITEC2.dbo.PRE_CREATEUR,DISTRITEC2.dbo.PRE_CLOTURE,DISTRITEC2.dbo.PRE_REMBMAX,DISTRITEC2.dbo.PRE_CALCFRACTION,
DISTRITEC2.dbo.PRE_REMBEFFECTUE,DISTRITEC2.dbo.PRE_ECHEANCIER,DISTRITEC2.dbo.PRE_BENEFRSGU,DISTRITEC2.dbo.PRE_NONLIMITE10P)
select rtsource.PRE_SALARIE,rtsource.PRE_ORDRE,rtsource.PRE_LIBELLE,rtsource.PRE_DATEDEBUT,rtsource.PRE_DATEFIN,rtsource.PRE_MONTANTMENS,
rtsource.PRE_MONTANTTOT,rtsource.PRE_NBMOIS,rtsource.PRE_nbjours,rtsource.PRE_SOLDE,rtsource.PRE_ACTIF,rtsource.PRE_RIB,rtsource.PRE_RETENUESAL,
rtsource.PRE_TYPEPAIERET,rtsource.PRE_RUBRIQUE,rtsource.PRE_BENEFICIAIRERS,rtsource.PRE_NIVEAURS,rtsource.PRE_DATECREATION,rtsource.PRE_DATEMODIF,
rtsource.PRE_CREATEUR,rtsource.PRE_CLOTURE,rtsource.PRE_REMBMAX,rtsource.PRE_CALCFRACTION,rtsource.PRE_REMBEFFECTUE,rtsource.PRE_ECHEANCIER,
rtsource.PRE_BENEFRSGU,rtsource.PRE_NONLIMITE10P
from DISTRITEC.dbo.RETENUESALAIRE as rtsource inner join DISTRITEC2.dbo.RETENUESALAIRE as rttarget on (rtsource.PRE_SALARIE<>rttarget.PRE_SALARIE and rtsource.PRE_ORDRE<>rttarget.PRE_ORDRE) |
Partager