Start Processing : 2025-03-15 01:49:42
0 rows affectedUPDATE db_bombora_account_report
SET _industry = (CASE
WHEN _domain = 'kdrp.com' THEN 'Manufacturing > Food & Beverage'
WHEN _domain = 'pernodricard.com' THEN 'Manufacturing > Food & Beverage'
WHEN _domain = 'cwine.com' THEN 'Manufacturing > Food & Beverage'
END)
WHERE _domain IN ('kdrp.com','pernodricard.com','cwine.com');
[1] 4.89 seconds -> 0 rows affected
UPDATE db_bombora_account_report
SET _domain = (CASE
WHEN _domain='b-and-q.co.uk' THEN 'diy.com'
ELSE 'diy.com'
END)
WHERE _companyName IN ('B&Q plc');
[900] 2.53 seconds -> 0 rows affected