1
2
3
4
5
6
7
| UPDATE t_temp INNER JOIN T_Incidents ON t_temp.REF_Incident = T_Incidents.REF_Incident SET T_Incidents.REF_Incident = [t_temp].REF_Incident, T_Incidents.Ref_SLA = [t_temp].[Ref_SLA], T_Incidents.Ref_Plage_Service = [t_temp].[Ref_Plage_Service], T_Incidents.Respect_SLA = [t_temp].[Respect_SLA], T_Incidents.Ref_Qualif = [t_temp].[Ref_Qualif], T_Incidents.Ref_Categorie = [t_temp].[Ref_Categorie], T_Incidents.Ref_Group_Resol = [t_temp].[Ref_Group_Resol], T_Incidents.Ref_Priorite = [t_temp].[Ref_Priorite], T_Incidents.Date_Creation = [t_temp].[Date_Creation], T_Incidents.Date_cloture = [t_temp].[Date_cloture], T_Incidents.Date_Dernier_changement = [t_temp].[Date_Dernier_changement], T_Incidents.Date_Acceptation = [t_temp].[Date_Acceptation], T_Incidents.Date_Resolution = [t_temp].[Date_Resolution], T_Incidents.Reouverture = [t_temp].[Reouverture], T_Incidents.Niveau_Resol = [t_temp].[Niveau_Resol], T_Incidents.Ref_Statut = [t_temp].[Ref_Statut]," & _
" T_Incidents.Ref_Dernier_Action = [t_temp].[Ref_Dernier_Action], T_Incidents.Ref_Origine = [t_temp].[Ref_Origine], T_Incidents.Nb_Reouv = [t_temp].[Nb_Reouv], T_Incidents.Nb_Reassign = [t_temp].[Nb_Reassign], T_Incidents.Ref_Assigne_a = [t_temp].[Ref_Assigne_a], T_Incidents.Délai_traitement_HG = [t_temp].[Délai_traitement_HG], T_Incidents.Ponderation = [t_temp].[Ponderation], T_Incidents.Relance_Intervenant = [t_temp].[Relance_Intervenant], T_Incidents.Relance_Utilisateur = [t_temp].[Relance_Utilisateur], T_Incidents.Date_mail = [t_temp].[Date_mail], T_Incidents.No_Client = [t_temp].[No_Client], T_Incidents.CI = [t_temp].[CI], T_Incidents.Date_First_trans = [t_temp].[Date_First_trans], T_Incidents.Date_detection = [t_temp].[Date_detection], T_Incidents.Ref_Client = [t_temp].[Ref_Client], T_Incidents.Ref_Criticite = [t_temp].[Ref_Criticite], T_Incidents.Ref_Impact = [t_temp].[Ref_Impact], T_Incidents.Incid_Majeur = [t_temp].[Incid_Majeur], T_Incidents.Incid_prod = [t_temp].[Incid_prod]," & _
" T_Incidents.Code_facture = [t_temp].[Code_facture], T_Incidents.Comment_Resol = [t_temp].[Comment_Resol], T_Incidents.Resume = [t_temp].[Resume], T_Incidents.Recapitulatif = [t_temp].[Recapitulatif]" & _
" WHERE(((T_Incidents.REF_Incident) <> [t_temp].REF_Incident Or (T_Incidents.REF_Incident) Is Null)) Or (((T_Incidents.Ref_SLA) <> [t_temp].[Ref_SLA] Or (T_Incidents.Ref_SLA) Is Null)) Or (((T_Incidents.Ref_Plage_Service) <> [t_temp].[Ref_Plage_Service] Or (T_Incidents.Ref_Plage_Service) Is Null)) Or (((T_Incidents.Respect_SLA) <> [t_temp].[Respect_SLA] Or (T_Incidents.Respect_SLA) Is Null)) Or (((T_Incidents.Ref_Qualif) <> [t_temp].[Ref_Qualif] Or (T_Incidents.Ref_Qualif) Is Null)) Or (((T_Incidents.Ref_Categorie) <> [t_temp].[Ref_Categorie] Or (T_Incidents.Ref_Categorie) Is Null)) Or (((T_Incidents.Ref_Group_Resol) <> [t_temp].[Ref_Group_Resol] Or (T_Incidents.Ref_Group_Resol) Is Null)) Or (((T_Incidents.Ref_Priorite) <> [t_temp].[Ref_Priorite] Or (T_Incidents.Ref_Priorite) Is Null)) Or (((T_Incidents.Date_Creation) <> [t_temp].[Date_Creation] Or (T_Incidents.Date_Creation) Is Null)) OR (((T_Incidents.Date_cloture)<>[t_temp].[Date_cloture] Or (T_Incidents.Date_cloture) Is Null))" & _
" OR (((T_Incidents.Date_Dernier_changement)<>[t_temp].[Date_Dernier_changement] Or (T_Incidents.Date_Dernier_changement) Is Null)) OR (((T_Incidents.Date_Acceptation)<>[t_temp].[Date_Acceptation] Or (T_Incidents.Date_Acceptation) Is Null)) OR (((T_Incidents.Date_Resolution)<>[t_temp].[Date_Resolution] Or (T_Incidents.Date_Resolution) Is Null)) OR (((T_Incidents.Reouverture)<>[t_temp].[Reouverture] Or (T_Incidents.Reouverture) Is Null)) OR (((T_Incidents.Niveau_Resol)<>[t_temp].[Niveau_Resol] Or (T_Incidents.Niveau_Resol) Is Null)) OR (((T_Incidents.Ref_Statut)<>[t_temp].[Ref_Statut] Or (T_Incidents.Ref_Statut) Is Null)) OR (((T_Incidents.Ref_Dernier_Action)<>[t_temp].[Ref_Dernier_Action] Or (T_Incidents.Ref_Dernier_Action) Is Null)) OR (((T_Incidents.Ref_Origine)<>[t_temp].[Ref_Origine] Or (T_Incidents.Ref_Origine) Is Null)) OR (((T_Incidents.Nb_Reouv)<>[t_temp].[Nb_Reouv] Or (T_Incidents.Nb_Reouv) Is Null)) OR (((T_Incidents.Nb_Reassign)<>[t_temp].[Nb_Reassign]" & _
" Or (T_Incidents.Nb_Reassign) Is Null)) OR (((T_Incidents.Ref_Assigne_a)<>[t_temp].[Ref_Assigne_a] Or (T_Incidents.Ref_Assigne_a) Is Null)) OR (((T_Incidents.Délai_traitement_HG)<>[t_temp].[Délai_traitement_HG] Or (T_Incidents.Délai_traitement_HG) Is Null)) OR (((T_Incidents.Ponderation)<>[t_temp].[Ponderation] Or (T_Incidents.Ponderation) Is Null)) OR (((T_Incidents.Relance_Intervenant)<>[t_temp].[Relance_Intervenant] Or (T_Incidents.Relance_Intervenant) Is Null)) OR (((T_Incidents.Relance_Utilisateur)<>[t_temp].[Relance_Utilisateur] Or (T_Incidents.Relance_Utilisateur) Is Null)) OR (((T_Incidents.Date_mail)<>[t_temp].[Date_mail] Or (T_Incidents.Date_mail) Is Null)) OR (((T_Incidents.No_Client)<>[t_temp].[No_Client] Or (T_Incidents.No_Client) Is Null)) OR (((T_Incidents.CI)<>[t_temp].[CI] Or (T_Incidents.CI) Is Null)) OR (((T_Incidents.Date_First_trans)<>[t_temp].[Date_First_trans] Or (T_Incidents.Date_First_trans) Is Null)) OR (((T_Incidents.Date_detection)<>[t_temp].[Date_detection]" & _
" Or (T_Incidents.Date_detection) Is Null))OR (((T_Incidents.Ref_Client)<>[t_temp].[Ref_Client] Or (T_Incidents.Ref_Client) Is Null)) OR (((T_Incidents.Ref_Criticite)<>[t_temp].[Ref_Criticite] Or (T_Incidents.Ref_Criticite) Is Null)) OR (((T_Incidents.Ref_Impact)<>[t_temp].[Ref_Impact] Or (T_Incidents.Ref_Impact) Is Null)) OR (((T_Incidents.Incid_Majeur)<>[t_temp].[Incid_Majeur] Or (T_Incidents.Incid_Majeur) Is Null)) OR (((T_Incidents.Incid_prod)<>[t_temp].[Incid_prod] Or (T_Incidents.Incid_prod) Is Null)) OR (((T_Incidents.Code_facture)<>[t_temp].[Code_facture] Or (T_Incidents.Code_facture) Is Null)) OR (((T_Incidents.Comment_Resol)<>[t_temp].[Comment_Resol] Or (T_Incidents.Comment_Resol) Is Null)) OR (((T_Incidents.Resume)<>[t_temp].[Resume] Or (T_Incidents.Resume) Is Null)) OR (((T_Incidents.Recapitulatif)<>[t_temp].[Recapitulatif] Or (T_Incidents.Recapitulatif) Is Null));" |
Bonne pratique pour un sous formulaire
Répondre avec citation
). 
Il me semblait que tu faisais allusion à une requête de suppression, ici c'est de la mise à jour, donc je suis moins étonné du temps d'exécution.
Partager