Start Processing : 2024-09-20 02:43:41<BR>0 rows affectedupdate db_zoominfo 
set _datePurchased = CURDATE()
where _datePurchased is null;<BR>[1] 2.01 seconds -> 0 rows affected<BR>update w_routables
set _function = CASE
WHEN _title like '%Mine%' THEN 'Mining & Construction'
WHEN _title like '%Mining%' THEN 'Mining & Construction'
WHEN _title like '%Energy%' THEN 'Mining & Construction'
WHEN _title like '%Contractor%' THEN 'Mining & Construction'
WHEN _title like '%maintenance%' THEN 'Security & Maintenance'
WHEN _title like '%engineer%' THEN 'Engineering & Technical'
WHEN _title like '%electri%' THEN 'Engineering & Technical'
WHEN _title like '%safety%' THEN 'Health & Safety'
WHEN _title like '%Chief Compliance Officer%' THEN 'Legal & Compliance'
WHEN _title like '%construction%' THEN 'Mining & Construction'
WHEN _title like '%Chief Legal Officer%' THEN 'Legal & Compliance'
WHEN _title like '%Chief Risk Officer%' THEN 'Legal & Compliance'
WHEN _title like '%Chief Revenue Officer%' THEN 'Accounting & Finance'
WHEN _title like '%CDO%' THEN 'Information Technology & Security'
WHEN _title like '%Chief Digital Officer%' THEN 'Information Technology & Security'
WHEN _title like '%Chief Information Officer%' THEN 'Information Technology & Security'
WHEN _title like '%CIO%' THEN 'Information Technology & Security'
WHEN _title like '%Chief Technology Officer%' THEN 'Information Technology & Security'
WHEN _title like '%CFO%' THEN 'Accounting & Finance'
WHEN _title like '%Chief Financ%' THEN 'Accounting & Finance'
WHEN _title like '%Chief Operat%' THEN 'Operations'
WHEN _title like '%Software%' THEN 'Information Technology & Security'
WHEN _title like '%Information Technology%' THEN 'Information Technology & Security'
WHEN _title like '%Information Security%' THEN 'Information Technology & Security'
WHEN _title like '%Strat%' THEN 'Strategy'
WHEN _title like '%Sales%' THEN 'Sales & Marketing'
WHEN _title like '%Marketing%' THEN 'Sales & Marketing'
WHEN _title like '%Legal%' THEN 'Legal & Compliance'
WHEN _title like '%Risk%' THEN 'Legal & Compliance'
WHEN _title like '%Procur%' THEN 'Sourcing & Procurement'
WHEN _title like '%Purchas%' THEN 'Sourcing & Procurement'
WHEN _title like '%buyer%' THEN 'Sourcing & Procurement'
WHEN _title like '%Accounting%' THEN 'Accounting & Finance'
WHEN _title like '%Financ%' THEN 'Accounting & Finance'
WHEN _title like '%Operat%' THEN 'Operations'
WHEN _title like '%Complianc%' THEN 'Legal & Compliance'
WHEN _title like '% It%' THEN 'Information Technology & Security'
WHEN _title like '%Counsel%' THEN 'Legal & Compliance'
WHEN _title like '%technic%' THEN 'Engineering & Technical'
WHEN _title like '%mechanic%' THEN 'Engineering & Technical'
WHEN _title like '%machin%' THEN 'Engineering & Technical'
WHEN _title like '%robotics%' THEN 'Engineering & Technical'
WHEN _title like '%warehous%' THEN 'Supply Chain & Logistics'
WHEN _title like '%supply chain%' THEN 'Supply Chain & Logistics'
WHEN _title like '%suppl%' THEN 'Supply Chain & Logistics'
WHEN _title like '%CAD%' THEN 'Design & Architecture'
WHEN _title like '%Design%' THEN 'Design & Architecture'
WHEN _title like '%BIM%' THEN 'Design & Architecture'
WHEN _title like '%architect%' THEN 'Design & Architecture'
WHEN _title like '%techno%' THEN 'Information Technology & Security'
WHEN _title like '%information%' THEN 'Information Technology & Security'
WHEN _title like '%research%' THEN 'Research & Development'
WHEN _title like '%innovation%' THEN 'Research & Development'
WHEN _title like '%Project%' THEN 'Project Management & Development'
WHEN _title like '%Superintendent%' THEN 'Project Management & Development'
WHEN _title like '%Superintendant%' THEN 'Project Management & Development'
WHEN _title like '%Plant%' THEN 'Project Management & Development'
WHEN _title like '%Supervisor%' THEN 'Project Management & Development'
WHEN _title like '%Yard Manager%' THEN 'Project Management & Development'
WHEN _title like '%estimat%' THEN 'Project Management & Development'
WHEN _title like '%material%' THEN 'Sourcing & Procurement'
WHEN _title like '%contract%' THEN 'Sourcing & Procurement'
WHEN _title like '%human resource%' THEN 'Human Resource'
WHEN _title like '%Equipment%' THEN 'Engineering & Technical'
WHEN _title like '%scien%' THEN 'Engineering & Technical'
WHEN _title like '%Drill%' THEN 'Mining & Construction'
WHEN _title like '%Process%' THEN 'Operations'
WHEN _title like '%Production%' THEN 'Production'
WHEN _title like '%asset%' THEN 'Accounting & Finance'
WHEN _title like '%CRO%' THEN 'Legal & Compliance'
WHEN _title like '%ops%' THEN 'Operations'
WHEN _title like '%Chief Strat%' THEN 'Strategy'
WHEN _title like '%CSO%' THEN 'Operations'
WHEN _title like '%General Manager%' THEN 'Project Management & Development'
WHEN _title like '%Development%' THEN 'Project Management & Development'
WHEN _title like '%Managing Director%' THEN 'Project Management & Development'
WHEN _title like '%Chairman%' THEN 'Executive'
WHEN _title like '%President%' THEN 'Executive'
WHEN _title like '%CEO%' THEN 'Executive'
WHEN _title like '%Chief Executive%' THEN 'Executive'
WHEN _title like '%C.E.O.%' THEN 'Executive'
WHEN _title like '%Founder%' THEN 'Executive'
WHEN _title like '%Scheduler%' THEN 'Project Management & Development'
WHEN _title like '%R&D%' THEN 'Research & Development'
WHEN _title like '%optimi%' THEN 'Research & Development'
WHEN _title like '%haulage%' THEN 'Mining & Construction'
WHEN _title like '%relocation%' THEN 'Mining & Construction'
WHEN _title like '%land%' THEN 'Mining & Construction'
WHEN _title like '%area%' THEN 'Mining & Construction'
WHEN _title like '%improv%' THEN 'Project Management & Development'
WHEN _title like '%Transport%' THEN 'Supply Chain & Logistics'
WHEN _title like '%Controller%' THEN 'Accounting & Finance'
WHEN _title like '%disposals%' THEN 'Mining & Construction'
WHEN _title like '%strip%' THEN 'Mining & Construction'
WHEN _title like '%gas%' THEN 'Mining & Construction'
WHEN _title like '%renewable%' THEN 'Mining & Construction'
WHEN _title like '%build%' THEN 'Mining & Construction'
WHEN _title like '%sector%' THEN 'Mining & Construction'
WHEN _title like '%conductor%' THEN 'Mining & Construction'
WHEN _title like '%power%' THEN 'Mining & Construction'
WHEN _title like '%extraction%' THEN 'Mining & Construction'
WHEN _title like '%hygien%' THEN 'Health & Safety'
WHEN _title like '%audit%' THEN 'Health & Safety'
WHEN _title like '%inspect%' THEN 'Health & Safety'
WHEN _title like '%services%' THEN 'Security & Maintenance'
WHEN _title like '%intelligence%' THEN 'Information Technology & Security'
WHEN _title like '%drafter%' THEN 'Design & Architecture'
WHEN _title like '%BI & Analytics%' THEN 'Sourcing & Procurement'
WHEN _title like '%sourc%' THEN 'Sourcing & Procurement'
WHEN _title like '%fleet%' THEN 'Supply Chain & Logistics'
WHEN _title like '%logistic%' THEN 'Supply Chain & Logistics'
WHEN _title like '%business%' THEN 'Operations'
WHEN _title like '%corporate%' THEN 'Operations'
WHEN _title like '%transformation%' THEN 'Project Management & Development'
WHEN _title like '%plan%' THEN 'Project Management & Development'
WHEN _title like '%application%' THEN 'Information Technology & Security'
WHEN _title like '%Executive%' THEN 'Executive'
WHEN _title like '%director%' THEN 'Project Management & Development'
WHEN _title like '%CTO%' THEN 'Information Technology & Security'
WHEN _title like '%COO%' THEN 'Operations'
WHEN _title like '%Manager%' THEN 'Project Management & Development'
WHEN _title like '%General Head%' THEN 'Project Management & Development'
WHEN _title like '%Partner%' THEN 'Shareholder'
WHEN _title like '%Head of%' THEN 'Project Management & Development'
WHEN _title like '%VP%' THEN 'Executive'
WHEN _title like '%account rep%' THEN 'Sales & Marketing'
WHEN _title like '%treasurer%' THEN 'Accounting & Finance'
WHEN _title like '%accountant%' THEN 'Accounting & Finance'
WHEN _title like '%owner%' THEN 'Executive'
ELSE 'Other'
END
where _title !=''<BR>[2] 2.04 seconds -> 0 rows affected<BR>