I got some errors.

1 - easilyPatId unknow (easilyPadId come from #temp2)

2 -target table ' DI628SW.NOYAU_PATIENT.noyau. TELEPHONE_PATIENT ' of the clause OUTPUT INTO cannot be next to a relation (primary key, foreign key). Constraint of found reference: ' FK_TELEPHONE_PATIENT_PATIENT '. Note tel_id is primary key and Identity field from [TELEPHONE ]but also a primary key but not identity from [TELEPHONE_PATIENT]

I think there something wrong in Ouput but I don't know where ?

INSERT INTO [DI628SW].[NOYAU_PATIENT].[noyau].[TELEPHONE] (

tel_categorie

,tel_numero

,tel_envoi_sms

,tel_principal

,tel_commentaire

,tel_administratif

,tel_actif

)

OUTPUT INSERTED.tel_id, INSERTED.easilyPatId

into [DI628SW].[NOYAU_PATIENT].[noyau].[TELEPHONE_PATIENT] (tel_id, pat_id)

SELECT

easilyTypeNumTelId,

cnetNumTel,

cnetSMS,

cnetnumeroPrincipal,

cnetCommentaire,

0,

1

FROM #temp2