Connexion réussie

UPDATE sedentaire SET s_manager = 'MANAGER' , s_manager_fonction = 'FONCTION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MANAG%') WHERE s_matricule = 'MATRICULE';
UPDATE sedentaire SET s_manager = 'MANCINI F.' , s_manager_fonction = 'RESPONSABLE DE L\'AGENCE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MANCI%') WHERE s_matricule = '90547';
UPDATE sedentaire SET s_manager = 'MANCINI F.' , s_manager_fonction = 'RESPONSABLE DE L\'AGENCE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MANCI%') WHERE s_matricule = '94184';
UPDATE sedentaire SET s_manager = 'MANCINI F.' , s_manager_fonction = 'RESPONSABLE DE L\'AGENCE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MANCI%') WHERE s_matricule = '95442';
UPDATE sedentaire SET s_manager = 'MANCINI F.' , s_manager_fonction = 'RESPONSABLE DE L\'AGENCE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MANCI%') WHERE s_matricule = '95548';
UPDATE sedentaire SET s_manager = 'MANCINI F.' , s_manager_fonction = 'RESPONSABLE DE L\'AGENCE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MANCI%') WHERE s_matricule = '93412';
UPDATE sedentaire SET s_manager = 'MISTRE A.' , s_manager_fonction = 'DIRECTEUR QHSSE - EXPLOITATION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MISTR%') WHERE s_matricule = '94178';
UPDATE sedentaire SET s_manager = 'MEREU JP' , s_manager_fonction = 'RESP. DE L\'ACTIVITE PASSAGES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MEREU%') WHERE s_matricule = '95571';
UPDATE sedentaire SET s_manager = 'MEREU JP' , s_manager_fonction = 'RESP. DE L\'ACTIVITE PASSAGES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MEREU%') WHERE s_matricule = '22114';
UPDATE sedentaire SET s_manager = 'MEREU JP' , s_manager_fonction = 'RESP. DE L\'ACTIVITE PASSAGES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MEREU%') WHERE s_matricule = '94793';
UPDATE sedentaire SET s_manager = 'MEREU JP' , s_manager_fonction = 'RESP. DE L\'ACTIVITE PASSAGES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MEREU%') WHERE s_matricule = '95592';
UPDATE sedentaire SET s_manager = 'MANCINI F.' , s_manager_fonction = 'RESP. DE L\'ACTIVITE PASSAGES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MANCI%') WHERE s_matricule = '95531';
UPDATE sedentaire SET s_manager = 'EBRAVE MA' , s_manager_fonction = 'RESPONSABLE D\'EXPLOITATION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%EBRAV%') WHERE s_matricule = '21286';
UPDATE sedentaire SET s_manager = 'EBRAVE MA' , s_manager_fonction = 'RESPONSABLE D\'EXPLOITATION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%EBRAV%') WHERE s_matricule = '94591';
UPDATE sedentaire SET s_manager = 'EBRAVE MA' , s_manager_fonction = 'RESPONSABLE D\'EXPLOITATION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%EBRAV%') WHERE s_matricule = '94872';
UPDATE sedentaire SET s_manager = 'EBRAVE MA' , s_manager_fonction = 'RESPONSABLE D\'EXPLOITATION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%EBRAV%') WHERE s_matricule = '95190';
UPDATE sedentaire SET s_manager = 'EBRAVE MA' , s_manager_fonction = 'RESPONSABLE D\'EXPLOITATION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%EBRAV%') WHERE s_matricule = '94195';
UPDATE sedentaire SET s_manager = 'EBRAVE MA' , s_manager_fonction = 'RESPONSABLE D\'EXPLOITATION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%EBRAV%') WHERE s_matricule = '94205';
UPDATE sedentaire SET s_manager = 'EBRAVE MA' , s_manager_fonction = 'RESPONSABLE D\'EXPLOITATION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%EBRAV%') WHERE s_matricule = '94853';
UPDATE sedentaire SET s_manager = 'EBRAVE MA' , s_manager_fonction = 'RESPONSABLE D\'EXPLOITATION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%EBRAV%') WHERE s_matricule = '95181';
UPDATE sedentaire SET s_manager = 'EBRAVE MA' , s_manager_fonction = 'RESPONSABLE D\'EXPLOITATION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%EBRAV%') WHERE s_matricule = '95637';
UPDATE sedentaire SET s_manager = 'EBRAVE MA' , s_manager_fonction = 'RESPONSABLE D\'EXPLOITATION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%EBRAV%') WHERE s_matricule = '94536';
UPDATE sedentaire SET s_manager = 'EBRAVE MA' , s_manager_fonction = 'RESPONSABLE D\'EXPLOITATION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%EBRAV%') WHERE s_matricule = '74554';
UPDATE sedentaire SET s_manager = 'EBRAVE MA' , s_manager_fonction = 'RESPONSABLE D\'EXPLOITATION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%EBRAV%') WHERE s_matricule = '93930';
UPDATE sedentaire SET s_manager = 'MISTRE A.' , s_manager_fonction = 'DIRECTEUR QHSSE - EXPLOITATION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MISTR%') WHERE s_matricule = '94705';
UPDATE sedentaire SET s_manager = 'KARMOUS S.' , s_manager_fonction = 'RESPONSABLE AGENCE DE MARSEILLE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%KARMO%') WHERE s_matricule = '94699';
UPDATE sedentaire SET s_manager = 'DE BERNARDI C' , s_manager_fonction = 'ADJ. RESPONSABLE SERVICE FRET', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%DE BE%') WHERE s_matricule = '20057';
UPDATE sedentaire SET s_manager = 'DE BERNARDI C' , s_manager_fonction = 'ADJ. RESPONSABLE SERVICE FRET', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%DE BE%') WHERE s_matricule = '68252';
UPDATE sedentaire SET s_manager = 'DE BERNARDI C' , s_manager_fonction = 'ADJ. RESPONSABLE SERVICE FRET', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%DE BE%') WHERE s_matricule = '86712';
UPDATE sedentaire SET s_manager = 'DE BERNARDI C' , s_manager_fonction = 'ADJ. RESPONSABLE SERVICE FRET', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%DE BE%') WHERE s_matricule = '95701';
UPDATE sedentaire SET s_manager = 'TOMASI G.' , s_manager_fonction = 'RESPONSABLE SERVICE PASSAGES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%TOMAS%') WHERE s_matricule = '21361';
UPDATE sedentaire SET s_manager = 'TOMASI G.' , s_manager_fonction = 'RESPONSABLE SERVICE PASSAGES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%TOMAS%') WHERE s_matricule = '90616';
UPDATE sedentaire SET s_manager = 'TOMASI G.' , s_manager_fonction = 'RESPONSABLE SERVICE PASSAGES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%TOMAS%') WHERE s_matricule = '95314';
UPDATE sedentaire SET s_manager = 'TOMASI G.' , s_manager_fonction = 'RESPONSABLE SERVICE PASSAGES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%TOMAS%') WHERE s_matricule = '21365';
UPDATE sedentaire SET s_manager = 'TOMASI G.' , s_manager_fonction = 'RESPONSABLE SERVICE PASSAGES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%TOMAS%') WHERE s_matricule = '73555';
UPDATE sedentaire SET s_manager = 'TOMASI G.' , s_manager_fonction = 'RESPONSABLE SERVICE PASSAGES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%TOMAS%') WHERE s_matricule = '94806';
UPDATE sedentaire SET s_manager = 'TOMASI G.' , s_manager_fonction = 'RESPONSABLE SERVICE PASSAGES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%TOMAS%') WHERE s_matricule = '95090';
UPDATE sedentaire SET s_manager = 'TOMASI G.' , s_manager_fonction = 'RESPONSABLE SERVICE PASSAGES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%TOMAS%') WHERE s_matricule = '95362';
UPDATE sedentaire SET s_manager = 'TOMASI G.' , s_manager_fonction = 'RESPONSABLE SERVICE PASSAGES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%TOMAS%') WHERE s_matricule = '95388';
UPDATE sedentaire SET s_manager = 'TOMASI G.' , s_manager_fonction = 'RESPONSABLE SERVICE PASSAGES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%TOMAS%') WHERE s_matricule = '95626';
UPDATE sedentaire SET s_manager = 'TOMASI G.' , s_manager_fonction = 'RESPONSABLE SERVICE PASSAGES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%TOMAS%') WHERE s_matricule = '95829';
UPDATE sedentaire SET s_manager = 'TOMASI G.' , s_manager_fonction = 'RESPONSABLE SERVICE PASSAGES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%TOMAS%') WHERE s_matricule = '94832';
UPDATE sedentaire SET s_manager = 'TOMASI G.' , s_manager_fonction = 'RESPONSABLE SERVICE PASSAGES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%TOMAS%') WHERE s_matricule = '62928';
UPDATE sedentaire SET s_manager = 'TOMASI G.' , s_manager_fonction = 'RESPONSABLE SERVICE PASSAGES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%TOMAS%') WHERE s_matricule = '72373';
UPDATE sedentaire SET s_manager = 'KARMOUS S.' , s_manager_fonction = 'RESPONSABLE AGENCE DE MARSEILLE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%KARMO%') WHERE s_matricule = '85868';
UPDATE sedentaire SET s_manager = 'KARMOUS S.' , s_manager_fonction = 'RESPONSABLE AGENCE DE MARSEILLE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%KARMO%') WHERE s_matricule = '81683';
UPDATE sedentaire SET s_manager = 'KARMOUS S.' , s_manager_fonction = 'RESPONSABLE AGENCE DE MARSEILLE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%KARMO%') WHERE s_matricule = '94714';
UPDATE sedentaire SET s_manager = 'KARMOUS S.' , s_manager_fonction = 'RESPONSABLE AGENCE DE MARSEILLE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%KARMO%') WHERE s_matricule = '20204';
UPDATE sedentaire SET s_manager = 'KARMOUS S.' , s_manager_fonction = 'RESPONSABLE AGENCE DE MARSEILLE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%KARMO%') WHERE s_matricule = '94708';
UPDATE sedentaire SET s_manager = 'KARMOUS S.' , s_manager_fonction = 'RESPONSABLE AGENCE DE MARSEILLE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%KARMO%') WHERE s_matricule = '95077';
UPDATE sedentaire SET s_manager = 'KARMOUS S.' , s_manager_fonction = 'RESPONSABLE AGENCE DE MARSEILLE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%KARMO%') WHERE s_matricule = '81692';
UPDATE sedentaire SET s_manager = 'KARMOUS S.' , s_manager_fonction = 'RESPONSABLE AGENCE DE MARSEILLE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%KARMO%') WHERE s_matricule = '95708';
UPDATE sedentaire SET s_manager = 'MISTRE A.' , s_manager_fonction = 'DIRECTEUR QHSSE - EXPLOITATION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MISTR%') WHERE s_matricule = '20292';
UPDATE sedentaire SET s_manager = 'KARMOUS S.' , s_manager_fonction = 'RESPONSABLE AGENCE DE MARSEILLE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%KARMO%') WHERE s_matricule = '68954';
UPDATE sedentaire SET s_manager = 'KARMOUS S.' , s_manager_fonction = 'RESPONSABLE AGENCE DE MARSEILLE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%KARMO%') WHERE s_matricule = '73545';
UPDATE sedentaire SET s_manager = 'KARMOUS S.' , s_manager_fonction = 'RESPONSABLE AGENCE DE MARSEILLE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%KARMO%') WHERE s_matricule = '90073';
UPDATE sedentaire SET s_manager = 'KARMOUS S.' , s_manager_fonction = 'RESPONSABLE AGENCE DE MARSEILLE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%KARMO%') WHERE s_matricule = '90194';
UPDATE sedentaire SET s_manager = 'KARMOUS S.' , s_manager_fonction = 'RESPONSABLE AGENCE DE MARSEILLE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%KARMO%') WHERE s_matricule = '90319';
UPDATE sedentaire SET s_manager = 'LLOVERA A.' , s_manager_fonction = 'DIRECTRICE DES RESSOURCES HUMAINES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LLOVE%') WHERE s_matricule = '90078';
UPDATE sedentaire SET s_manager = 'QUARANTA A.' , s_manager_fonction = 'REPONSABLE COMMERCIAL(E) PAX', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%QUARA%') WHERE s_matricule = '22115';
UPDATE sedentaire SET s_manager = 'BOUZELMAT S.' , s_manager_fonction = 'RESP. MAITRE D\'OUV SYS COM', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%BOUZE%') WHERE s_matricule = '95533';
UPDATE sedentaire SET s_manager = 'CANETTI M.' , s_manager_fonction = 'RESPONSABLE SCE CLIENTS F/O', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%CANET%') WHERE s_matricule = '95735';
UPDATE sedentaire SET s_manager = 'CANETTI M.' , s_manager_fonction = 'RESPONSABLE SCE CLIENTS F/O', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%CANET%') WHERE s_matricule = '20233';
UPDATE sedentaire SET s_manager = 'CANETTI M.' , s_manager_fonction = 'RESPONSABLE SCE CLIENTS F/O', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%CANET%') WHERE s_matricule = '21284';
UPDATE sedentaire SET s_manager = 'CANETTI M.' , s_manager_fonction = 'RESPONSABLE SCE CLIENTS F/O', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%CANET%') WHERE s_matricule = '95177';
UPDATE sedentaire SET s_manager = 'CANETTI M.' , s_manager_fonction = 'RESPONSABLE SCE CLIENTS F/O', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%CANET%') WHERE s_matricule = '95587';
UPDATE sedentaire SET s_manager = 'CANETTI M.' , s_manager_fonction = 'RESPONSABLE SCE CLIENTS F/O', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%CANET%') WHERE s_matricule = '96166';
UPDATE sedentaire SET s_manager = 'CANETTI M.' , s_manager_fonction = 'RESPONSABLE SCE CLIENTS F/O', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%CANET%') WHERE s_matricule = '96222';
UPDATE sedentaire SET s_manager = 'MISTRE A.' , s_manager_fonction = 'DIRECTEUR QHSSE - EXPLOITATION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MISTR%') WHERE s_matricule = '21274';
UPDATE sedentaire SET s_manager = 'MISTRE A.' , s_manager_fonction = 'DIRECTEUR QHSSE - EXPLOITATION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MISTR%') WHERE s_matricule = '22636';
UPDATE sedentaire SET s_manager = 'MISTRE A.' , s_manager_fonction = 'DIRECTEUR QHSSE - EXPLOITATION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MISTR%') WHERE s_matricule = '91536';
UPDATE sedentaire SET s_manager = 'MAINGUY P.' , s_manager_fonction = 'DIRECTEUR COMMERCIAL MARKETING', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MAING%') WHERE s_matricule = '94141';
UPDATE sedentaire SET s_manager = 'BOUZELMAT S.' , s_manager_fonction = 'RESP. MAITRE D\'OUV SYS COM', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%BOUZE%') WHERE s_matricule = '63607';
UPDATE sedentaire SET s_manager = 'MAINGUY P.' , s_manager_fonction = 'DIRECTEUR COMMERCIAL MARKETING', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MAING%') WHERE s_matricule = '62382';
UPDATE sedentaire SET s_manager = 'QUARANTA A.' , s_manager_fonction = 'REPONSABLE COMMERCIAL(E) PAX', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%QUARA%') WHERE s_matricule = '80667';
UPDATE sedentaire SET s_manager = 'VITI M.' , s_manager_fonction = 'RESPONSABLE SCE CLIENTS B/O', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%VITI %') WHERE s_matricule = '94384';
UPDATE sedentaire SET s_manager = 'VITI M.' , s_manager_fonction = 'RESPONSABLE SCE CLIENTS B/O', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%VITI %') WHERE s_matricule = '94401';
UPDATE sedentaire SET s_manager = 'VITI M.' , s_manager_fonction = 'RESPONSABLE SCE CLIENTS B/O', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%VITI %') WHERE s_matricule = '94342';
UPDATE sedentaire SET s_manager = 'MAINGUY P.' , s_manager_fonction = 'DIRECTEUR COMMERCIAL MARKETING', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MAING%') WHERE s_matricule = '91797';
UPDATE sedentaire SET s_manager = 'QUARANTA A.' , s_manager_fonction = 'REPONSABLE COMMERCIAL(E) PAX', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%QUARA%') WHERE s_matricule = '95386';
UPDATE sedentaire SET s_manager = 'MAINGUY P.' , s_manager_fonction = 'DIRECTEUR COMMERCIAL MARKETING', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MAING%') WHERE s_matricule = '94374';
UPDATE sedentaire SET s_manager = 'QUARANTA A.' , s_manager_fonction = 'REPONSABLE COMMERCIAL(E) PAX', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%QUARA%') WHERE s_matricule = '90111';
UPDATE sedentaire SET s_manager = 'QUARANTA A.' , s_manager_fonction = 'REPONSABLE COMMERCIAL(E) PAX', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%QUARA%') WHERE s_matricule = '78368';
UPDATE sedentaire SET s_manager = 'MAINGUY P.' , s_manager_fonction = 'DIRECTEUR COMMERCIAL MARKETING', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MAING%') WHERE s_matricule = '22614';
UPDATE sedentaire SET s_manager = 'AMOUR AS' , s_manager_fonction = 'RESPONSABLE YIELD MANAGEMENT', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%AMOUR%') WHERE s_matricule = '64108';
UPDATE sedentaire SET s_manager = 'AMOUR AS' , s_manager_fonction = 'RESPONSABLE YIELD MANAGEMENT', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%AMOUR%') WHERE s_matricule = '90032';
UPDATE sedentaire SET s_manager = 'ORTEGA F' , s_manager_fonction = 'DIRECTEUR ADM ET FINAN ADJ', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ORTEG%') WHERE s_matricule = '72644';
UPDATE sedentaire SET s_manager = 'ORTEGA F' , s_manager_fonction = 'DIRECTEUR ADM ET FINAN ADJ', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ORTEG%') WHERE s_matricule = '90696';
UPDATE sedentaire SET s_manager = 'DUBOIS E.' , s_manager_fonction = 'RESP. SERVICE CONTROLE GESTION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%DUBOI%') WHERE s_matricule = '78358';
UPDATE sedentaire SET s_manager = 'DUBOIS E.' , s_manager_fonction = 'RESP. SERVICE CONTROLE GESTION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%DUBOI%') WHERE s_matricule = '94971';
UPDATE sedentaire SET s_manager = 'ORTEGA F' , s_manager_fonction = 'DIRECTEUR ADM ET FINAN ADJ', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ORTEG%') WHERE s_matricule = '95500';
UPDATE sedentaire SET s_manager = 'DUBOIS E.' , s_manager_fonction = 'RESP. SERVICE CONTROLE GESTION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%DUBOI%') WHERE s_matricule = '95667';
UPDATE sedentaire SET s_manager = 'ORTEGA F' , s_manager_fonction = 'DIRECTEUR ADM ET FINAN ADJ', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ORTEG%') WHERE s_matricule = '22895';
UPDATE sedentaire SET s_manager = 'VERLAINE R.' , s_manager_fonction = 'DIRECTEUR S.I.', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%VERLA%') WHERE s_matricule = '91480';
UPDATE sedentaire SET s_manager = 'VERLAINE R.' , s_manager_fonction = 'DIRECTEUR S.I.', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%VERLA%') WHERE s_matricule = '95093';
UPDATE sedentaire SET s_manager = 'VERLAINE R.' , s_manager_fonction = 'DIRECTEUR S.I.', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%VERLA%') WHERE s_matricule = '67042';
UPDATE sedentaire SET s_manager = 'VERLAINE R.' , s_manager_fonction = 'DIRECTEUR S.I.', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%VERLA%') WHERE s_matricule = '91510';
UPDATE sedentaire SET s_manager = 'VERLAINE R.' , s_manager_fonction = 'DIRECTEUR S.I.', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%VERLA%') WHERE s_matricule = '94615';
UPDATE sedentaire SET s_manager = 'VERLAINE R.' , s_manager_fonction = 'DIRECTEUR S.I.', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%VERLA%') WHERE s_matricule = '85875';
UPDATE sedentaire SET s_manager = 'VERLAINE R.' , s_manager_fonction = 'DIRECTEUR S.I.', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%VERLA%') WHERE s_matricule = '90921';
UPDATE sedentaire SET s_manager = 'VERLAINE R.' , s_manager_fonction = 'DIRECTEUR S.I.', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%VERLA%') WHERE s_matricule = '74892';
UPDATE sedentaire SET s_manager = 'VERLAINE R.' , s_manager_fonction = 'DIRECTEUR S.I.', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%VERLA%') WHERE s_matricule = '70841';
UPDATE sedentaire SET s_manager = 'ROULET M.' , s_manager_fonction = 'RESP SCE FISCAL.& DROIT SOCIET', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ROULE%') WHERE s_matricule = '90041';
UPDATE sedentaire SET s_manager = 'ROULET M.' , s_manager_fonction = 'RESP SCE FISCAL.& DROIT SOCIET', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ROULE%') WHERE s_matricule = '92552';
UPDATE sedentaire SET s_manager = 'ROULET M.' , s_manager_fonction = 'RESP SCE FISCAL.& DROIT SOCIET', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ROULE%') WHERE s_matricule = '93214';
UPDATE sedentaire SET s_manager = 'VILLANOVA PA' , s_manager_fonction = 'DIRECTEUR GENERAL', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%VILLA%') WHERE s_matricule = '83528';
UPDATE sedentaire SET s_manager = 'ORTEGA F' , s_manager_fonction = 'DIRECTEUR ADM ET FINAN ADJ', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ORTEG%') WHERE s_matricule = '63799';
UPDATE sedentaire SET s_manager = 'ORTEGA F' , s_manager_fonction = 'DIRECTEUR ADM ET FINAN ADJ', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ORTEG%') WHERE s_matricule = '66782';
UPDATE sedentaire SET s_manager = 'ORTEGA F' , s_manager_fonction = 'DIRECTEUR ADM ET FINAN ADJ', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ORTEG%') WHERE s_matricule = '78074';
UPDATE sedentaire SET s_manager = 'ORTEGA F' , s_manager_fonction = 'DIRECTEUR ADM ET FINAN ADJ', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ORTEG%') WHERE s_matricule = '94613';
UPDATE sedentaire SET s_manager = 'ORTEGA F' , s_manager_fonction = 'DIRECTEUR ADM ET FINAN ADJ', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ORTEG%') WHERE s_matricule = '95931';
UPDATE sedentaire SET s_manager = 'VILLANOVA PA' , s_manager_fonction = 'DIRECTEUR GENERAL', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%VILLA%') WHERE s_matricule = '94978';
UPDATE sedentaire SET s_manager = 'ORTEGA F' , s_manager_fonction = 'DIRECTEUR ADM ET FINAN ADJ', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ORTEG%') WHERE s_matricule = '70992';
UPDATE sedentaire SET s_manager = 'ORTEGA F' , s_manager_fonction = 'DIRECTEUR ADM ET FINAN ADJ', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ORTEG%') WHERE s_matricule = '63735';
UPDATE sedentaire SET s_manager = 'ROCCASERRA S' , s_manager_fonction = 'RESPONSABLE SCE CLIENTS B/O', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ROCCA%') WHERE s_matricule = '94873';
UPDATE sedentaire SET s_manager = 'ROCCASERRA S' , s_manager_fonction = 'RESPONSABLE SCE CLIENTS B/O', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ROCCA%') WHERE s_matricule = '92885';
UPDATE sedentaire SET s_manager = 'CHAPPEL R.' , s_manager_fonction = 'DIRECTEUR FLOTTE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%CHAPP%') WHERE s_matricule = '95555';
UPDATE sedentaire SET s_manager = 'MATTEI P.' , s_manager_fonction = 'RESPONSABLE ARMEMENT', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MATTE%') WHERE s_matricule = '75097';
UPDATE sedentaire SET s_manager = 'MATTEI P.' , s_manager_fonction = 'RESPONSABLE ARMEMENT', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MATTE%') WHERE s_matricule = '85092';
UPDATE sedentaire SET s_manager = 'MATTEI P.' , s_manager_fonction = 'RESPONSABLE ARMEMENT', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MATTE%') WHERE s_matricule = '77761';
UPDATE sedentaire SET s_manager = 'MATTEI P.' , s_manager_fonction = 'RESPONSABLE ARMEMENT', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MATTE%') WHERE s_matricule = '90044';
UPDATE sedentaire SET s_manager = 'WAGNER E.' , s_manager_fonction = 'DIRECTEUR LIGNES ET PROGRAMME', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%WAGNE%') WHERE s_matricule = '94896';
UPDATE sedentaire SET s_manager = 'VILLANOVA PA' , s_manager_fonction = 'DIRECTEUR GENERAL', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%VILLA%') WHERE s_matricule = '87086';
UPDATE sedentaire SET s_manager = 'GADIENT P.' , s_manager_fonction = 'DIR.DEV.COMMERCIAL FRET M.C.M.', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%GADIE%') WHERE s_matricule = '94715';
UPDATE sedentaire SET s_manager = 'GADIENT P.' , s_manager_fonction = 'DIR.DEV.COMMERCIAL FRET M.C.M.', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%GADIE%') WHERE s_matricule = '95239';
UPDATE sedentaire SET s_manager = 'VILLANOVA PA' , s_manager_fonction = 'DIRECTEUR GENERAL', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%VILLA%') WHERE s_matricule = '90565';
UPDATE sedentaire SET s_manager = 'GADIENT P.' , s_manager_fonction = 'DIR.DEV.COMMERCIAL FRET M.C.M.', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%GADIE%') WHERE s_matricule = '73315';
UPDATE sedentaire SET s_manager = 'GADIENT P.' , s_manager_fonction = 'DIR.DEV.COMMERCIAL FRET M.C.M.', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%GADIE%') WHERE s_matricule = '94425';
UPDATE sedentaire SET s_manager = 'VILLANOVA PA' , s_manager_fonction = 'DIRECTEUR GENERAL', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%VILLA%') WHERE s_matricule = '93242';
UPDATE sedentaire SET s_manager = 'LOURDEAUX A.' , s_manager_fonction = 'DIRECTEUR ACHATS', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LOURD%') WHERE s_matricule = '81464';
UPDATE sedentaire SET s_manager = 'LOURDEAUX A.' , s_manager_fonction = 'DIRECTEUR ACHATS', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LOURD%') WHERE s_matricule = '21695';
UPDATE sedentaire SET s_manager = 'LLOVERA A.' , s_manager_fonction = 'DIRECTRICE DES RESSOURCES HUMAINES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LLOVE%') WHERE s_matricule = '91778';
UPDATE sedentaire SET s_manager = 'LLOVERA A.' , s_manager_fonction = 'DIRECTRICE DES RESSOURCES HUMAINES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LLOVE%') WHERE s_matricule = '94497';
UPDATE sedentaire SET s_manager = 'LLOVERA A.' , s_manager_fonction = 'DIRECTRICE DES RESSOURCES HUMAINES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LLOVE%') WHERE s_matricule = '90897';
UPDATE sedentaire SET s_manager = 'LLOVERA A.' , s_manager_fonction = 'DIRECTRICE DES RESSOURCES HUMAINES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LLOVE%') WHERE s_matricule = '95691';
UPDATE sedentaire SET s_manager = 'LLOVERA A.' , s_manager_fonction = 'DIRECTRICE DES RESSOURCES HUMAINES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LLOVE%') WHERE s_matricule = '90905';
UPDATE sedentaire SET s_manager = 'LLOVERA A.' , s_manager_fonction = 'DIRECTRICE DES RESSOURCES HUMAINES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LLOVE%') WHERE s_matricule = '72701';
UPDATE sedentaire SET s_manager = 'LLOVERA A.' , s_manager_fonction = 'DIRECTRICE DES RESSOURCES HUMAINES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LLOVE%') WHERE s_matricule = '22873';
UPDATE sedentaire SET s_manager = 'LLOVERA A.' , s_manager_fonction = 'DIRECTRICE DES RESSOURCES HUMAINES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LLOVE%') WHERE s_matricule = '66915';
UPDATE sedentaire SET s_manager = 'LLOVERA A.' , s_manager_fonction = 'DIRECTRICE DES RESSOURCES HUMAINES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LLOVE%') WHERE s_matricule = '90058';
UPDATE sedentaire SET s_manager = 'LLOVERA A.' , s_manager_fonction = 'DIRECTRICE DES RESSOURCES HUMAINES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LLOVE%') WHERE s_matricule = '96455';
UPDATE sedentaire SET s_manager = 'MARTINS S.' , s_manager_fonction = 'DRH ADJOINT', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MARTI%') WHERE s_matricule = '71760';
UPDATE sedentaire SET s_manager = 'MARTINS S.' , s_manager_fonction = 'DRH ADJOINT', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MARTI%') WHERE s_matricule = '76454';
UPDATE sedentaire SET s_manager = 'MARTINS S.' , s_manager_fonction = 'DRH ADJOINT', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MARTI%') WHERE s_matricule = '90069';
UPDATE sedentaire SET s_manager = 'MARTINS S.' , s_manager_fonction = 'DRH ADJOINT', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MARTI%') WHERE s_matricule = '95636';
UPDATE sedentaire SET s_manager = 'LLOVERA A.' , s_manager_fonction = 'DIRECTRICE DES RESSOURCES HUMAINES', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LLOVE%') WHERE s_matricule = '96460';
UPDATE sedentaire SET s_manager = 'ADENET L.' , s_manager_fonction = 'AGT ENCADREMENT/DIR.TECH.', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ADENE%') WHERE s_matricule = '23336';
UPDATE sedentaire SET s_manager = 'ADENET L.' , s_manager_fonction = 'AGT ENCADREMENT/DIR.TECH.', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ADENE%') WHERE s_matricule = '24078';
UPDATE sedentaire SET s_manager = 'ADENET L.' , s_manager_fonction = 'AGT ENCADREMENT/DIR.TECH.', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ADENE%') WHERE s_matricule = '22192';
UPDATE sedentaire SET s_manager = 'VILLANOVA PA' , s_manager_fonction = 'DIRECTEUR GENERAL', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%VILLA%') WHERE s_matricule = '22153';
UPDATE sedentaire SET s_manager = 'SALMERON L.' , s_manager_fonction = 'RESP. OPERATIONNEL ATELIERS', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%SALME%') WHERE s_matricule = '20223';
UPDATE sedentaire SET s_manager = 'ANKE J.' , s_manager_fonction = 'CHEF DE GROUPE MAGASIN LOGISTIQUE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ANKE %') WHERE s_matricule = '20278';
UPDATE sedentaire SET s_manager = 'ANKE J.' , s_manager_fonction = 'CHEF DE GROUPE MAGASIN LOGISTIQUE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ANKE %') WHERE s_matricule = '95175';
UPDATE sedentaire SET s_manager = 'SALMERON L.' , s_manager_fonction = 'RESP. OPERATIONNEL ATELIERS', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%SALME%') WHERE s_matricule = '87096';
UPDATE sedentaire SET s_manager = 'SALMERON L.' , s_manager_fonction = 'RESP. OPERATIONNEL ATELIERS', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%SALME%') WHERE s_matricule = '22659';
UPDATE sedentaire SET s_manager = 'ADENET L.' , s_manager_fonction = 'AGT ENCADREMENT/DIR.TECH.', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ADENE%') WHERE s_matricule = '94568';
UPDATE sedentaire SET s_manager = 'SALMERON L.' , s_manager_fonction = 'RESP. OPERATIONNEL ATELIERS', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%SALME%') WHERE s_matricule = '23211';
UPDATE sedentaire SET s_manager = 'SALIGNAC C.' , s_manager_fonction = 'CHEF DE GROUPE AMENAGEMENT', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%SALIG%') WHERE s_matricule = '96133';
UPDATE sedentaire SET s_manager = 'SALIGNAC C.' , s_manager_fonction = 'CHEF DE GROUPE AMENAGEMENT', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%SALIG%') WHERE s_matricule = '21381';
UPDATE sedentaire SET s_manager = 'SALIGNAC C.' , s_manager_fonction = 'CHEF DE GROUPE AMENAGEMENT', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%SALIG%') WHERE s_matricule = '23210';
UPDATE sedentaire SET s_manager = 'SALIGNAC C.' , s_manager_fonction = 'CHEF DE GROUPE AMENAGEMENT', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%SALIG%') WHERE s_matricule = '23385';
UPDATE sedentaire SET s_manager = 'SALIGNAC C.' , s_manager_fonction = 'CHEF DE GROUPE AMENAGEMENT', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%SALIG%') WHERE s_matricule = '22922';
UPDATE sedentaire SET s_manager = 'MISTRE A.' , s_manager_fonction = 'DIRECTEUR QHSSE - EXPLOITATION', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%MISTR%') WHERE s_matricule = '95122';
UPDATE sedentaire SET s_manager = 'COLORE F.' , s_manager_fonction = 'CHEF DE GROUPE FER', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%COLOR%') WHERE s_matricule = '23634';
UPDATE sedentaire SET s_manager = 'COLORE F.' , s_manager_fonction = 'CHEF DE GROUPE FER', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%COLOR%') WHERE s_matricule = '22514';
UPDATE sedentaire SET s_manager = 'COLORE F.' , s_manager_fonction = 'CHEF DE GROUPE FER', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%COLOR%') WHERE s_matricule = '22558';
UPDATE sedentaire SET s_manager = 'COLORE F.' , s_manager_fonction = 'CHEF DE GROUPE FER', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%COLOR%') WHERE s_matricule = '23282';
UPDATE sedentaire SET s_manager = 'LACOMBE S.' , s_manager_fonction = 'CHEF DE GROUPE MECANIQUE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LACOM%') WHERE s_matricule = '22495';
UPDATE sedentaire SET s_manager = 'LACOMBE S.' , s_manager_fonction = 'CHEF DE GROUPE MECANIQUE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LACOM%') WHERE s_matricule = '22497';
UPDATE sedentaire SET s_manager = 'LACOMBE S.' , s_manager_fonction = 'CHEF DE GROUPE MECANIQUE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LACOM%') WHERE s_matricule = '96118';
UPDATE sedentaire SET s_manager = 'ADENET L.' , s_manager_fonction = 'AGT ENCADREMENT/DIR.TECH.', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%ADENE%') WHERE s_matricule = '22602';
UPDATE sedentaire SET s_manager = 'LACOMBE S.' , s_manager_fonction = 'CHEF DE GROUPE MECANIQUE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LACOM%') WHERE s_matricule = '20596';
UPDATE sedentaire SET s_manager = 'LACOMBE S.' , s_manager_fonction = 'CHEF DE GROUPE MECANIQUE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LACOM%') WHERE s_matricule = '96464';
UPDATE sedentaire SET s_manager = 'LACOMBE S.' , s_manager_fonction = 'CHEF DE GROUPE MECANIQUE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LACOM%') WHERE s_matricule = '20162';
UPDATE sedentaire SET s_manager = 'LACOMBE S.' , s_manager_fonction = 'CHEF DE GROUPE MECANIQUE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LACOM%') WHERE s_matricule = '22494';
UPDATE sedentaire SET s_manager = 'LACOMBE S.' , s_manager_fonction = 'CHEF DE GROUPE MECANIQUE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LACOM%') WHERE s_matricule = '95237';
UPDATE sedentaire SET s_manager = 'LACOMBE S.' , s_manager_fonction = 'CHEF DE GROUPE MECANIQUE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LACOM%') WHERE s_matricule = '96441';
UPDATE sedentaire SET s_manager = 'LACOMBE S.' , s_manager_fonction = 'CHEF DE GROUPE MECANIQUE', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%LACOM%') WHERE s_matricule = '22563';
UPDATE sedentaire SET s_manager = 'QUARANTA A.' , s_manager_fonction = 'REPONSABLE COMMERCIAL(E) PAX', s_manager_id = (SELECT responsable_id FROM responsables WHERE responsable_nom LIKE '%QUARA%') WHERE s_matricule = '90153';