SELECT * FROM t_hu_master
WHERE hu_id IN ('LPN36672', 'LPN47939', 'LPN40175', 'LPN33650', 'LPN40103', 'LPN45520', 'LPN37185', 'LPN30578', 'LPN40773', 'LPN31369', 'LPN30991', 'LPN43845', 'LPN42816', 'LPN45300', 'LPN39120', 'LPN38894', 'LPN46744', 'LPN43757', 'LPN42345', 'LPN41350', 'LPN40016', 'LPN38237', 'LPN34058', 'LPN40102', 'LPN45367', 'LPN38649', 'LPN48190', 'LPN42162', 'LPN45711', 'LPN38754', 'LPN42909', 'LPN42445', 'LPN40755', 'LPN44987', 'LPN44139', 'LPN41866', 'LPN39967', 'LPN30630', 'LPN39418', 'LPN31524', 'LPN47093', 'LPN44571', 'LPN39778', 'LPN33837', 'LPN40556', 'LPN30925', 'LPN46969', 'LPN43602', 'LPN45403', 'LPN37347', 'LPN37251', 'LPN44217', 'LPN31366', 'LPN43632', 'LPN43430', 'LPN31651', 'LPN45094', 'LPN39872', 'LPN40921', 'LPN47103', 'LPN37308', 'LPN46373', 'LPN44955', 'LPN40258', 'LPN43743', 'LPN36770', 'LPN31804', 'LPN44633', 'LPN46987', 'LPN31380', 'LPN42501', 'LPN43432', 'LPN48212', 'LPN37202', 'LPN43198', 'LPN42422', 'LPN42655', 'LPN43523', 'LPN43939', 'LPN30302', 'LPN45952', 'LPN41998','LPN39750', 'LPN39783', 'LPN44788', 'LPN44339', 'LPN47804', 'LPN47856', 'LPN41398', 'LPN40920', 'LPN48003', 'LPN30145', 'LPN45870', 'LPN38272', 'LPN38996', 'LPN40635', 'LPN31596', 'LPN31491', 'LPN44141', 'LPN31259', 'LPN41934', 'LPN48231', 'LPN43857', 'LPN38821', 'LPN46399', 'LPN48093', 'LPN42915', 'LPN43034', 'LPN41326', 'LPN46191', 'LPN47544', 'LPN37209', 'LPN34846', 'LPN30208', 'LPN40340', 'LPN42362', 'LPN30446', 'LPN42497', 'LPN31155', 'LPN47180', 'LPN41571', 'LPN31895', 'LPN37241', 'LPN43276', 'LPN30246', 'LPN48463', 'LPN37905', 'LPN42147', 'LPN42812', 'LPN40662', 'LPN39128', 'LPN44952', 'LPN43863', 'LPN44242', 'LPN43906', 'LPN42093', 'LPN33688', 'LPN41833', 'LPN30036', 'LPN48432', 'LPN39339', 'LPN40840', 'LPN38366', 'LPN46569', 'LPN46511', 'LPN30926', 'LPN42234', 'LPN45671', 'LPN47189', 'LPN39806', '', 'LPN45726', 'LPN44428', 'LPN47385', 'LPN47271', 'LPN41288', 'LPN31372', 'LPN47493', 'LPN44310', 'LPN30749', 'LPN30241', 'LPN44668')
AND wh_id = '324'
AND (haz_material IS NOT NULL OR LENGTH(stop_id) > 8);

-- Executar antes do usuário fazer o processo (JÁ EXECUTADO POR MIM)
UPDATE t_hu_master SET haz_material = stop_id, stop_id = SUBSTR(stop_id, 0, 8)
WHERE hu_id IN ('LPN36672', 'LPN47939', 'LPN40175', 'LPN33650', 'LPN40103', 'LPN45520', 'LPN37185', 'LPN30578', 'LPN40773', 'LPN31369', 'LPN30991', 'LPN43845', 'LPN42816', 'LPN45300', 'LPN39120', 'LPN38894', 'LPN46744', 'LPN43757', 'LPN42345', 'LPN41350', 'LPN40016', 'LPN38237', 'LPN34058', 'LPN40102', 'LPN45367', 'LPN38649', 'LPN48190', 'LPN42162', 'LPN45711', 'LPN38754', 'LPN42909', 'LPN42445', 'LPN40755', 'LPN44987', 'LPN44139', 'LPN41866', 'LPN39967', 'LPN30630', 'LPN39418', 'LPN31524', 'LPN47093', 'LPN44571', 'LPN39778', 'LPN33837', 'LPN40556', 'LPN30925', 'LPN46969', 'LPN43602', 'LPN45403', 'LPN37347', 'LPN37251', 'LPN44217', 'LPN31366', 'LPN43632', 'LPN43430', 'LPN31651', 'LPN45094', 'LPN39872', 'LPN40921', 'LPN47103', 'LPN37308', 'LPN46373', 'LPN44955', 'LPN40258', 'LPN43743', 'LPN36770', 'LPN31804', 'LPN44633', 'LPN46987', 'LPN31380', 'LPN42501', 'LPN43432', 'LPN48212', 'LPN37202', 'LPN43198', 'LPN42422', 'LPN42655', 'LPN43523', 'LPN43939', 'LPN30302', 'LPN45952', 'LPN41998','LPN39750', 'LPN39783', 'LPN44788', 'LPN44339', 'LPN47804', 'LPN47856', 'LPN41398', 'LPN40920', 'LPN48003', 'LPN30145', 'LPN45870', 'LPN38272', 'LPN38996', 'LPN40635', 'LPN31596', 'LPN31491', 'LPN44141', 'LPN31259', 'LPN41934', 'LPN48231', 'LPN43857', 'LPN38821', 'LPN46399', 'LPN48093', 'LPN42915', 'LPN43034', 'LPN41326', 'LPN46191', 'LPN47544', 'LPN37209', 'LPN34846', 'LPN30208', 'LPN40340', 'LPN42362', 'LPN30446', 'LPN42497', 'LPN31155', 'LPN47180', 'LPN41571', 'LPN31895', 'LPN37241', 'LPN43276', 'LPN30246', 'LPN48463', 'LPN37905', 'LPN42147', 'LPN42812', 'LPN40662', 'LPN39128', 'LPN44952', 'LPN43863', 'LPN44242', 'LPN43906', 'LPN42093', 'LPN33688', 'LPN41833', 'LPN30036', 'LPN48432', 'LPN39339', 'LPN40840', 'LPN38366', 'LPN46569', 'LPN46511', 'LPN30926', 'LPN42234', 'LPN45671', 'LPN47189', 'LPN39806', '', 'LPN45726', 'LPN44428', 'LPN47385', 'LPN47271', 'LPN41288', 'LPN31372', 'LPN47493', 'LPN44310', 'LPN30749', 'LPN30241', 'LPN44668')
AND wh_Id = '324'
AND LENGTH(stop_id) > 8;

-- Executar após o usuário ter feito o processo.
UPDATE t_hu_master SET haz_material = NULL, stop_id = haz_material
WHERE hu_id IN ('LPN36672', 'LPN47939', 'LPN40175', 'LPN33650', 'LPN40103', 'LPN45520', 'LPN37185', 'LPN30578', 'LPN40773', 'LPN31369', 'LPN30991', 'LPN43845', 'LPN42816', 'LPN45300', 'LPN39120', 'LPN38894', 'LPN46744', 'LPN43757', 'LPN42345', 'LPN41350', 'LPN40016', 'LPN38237', 'LPN34058', 'LPN40102', 'LPN45367', 'LPN38649', 'LPN48190', 'LPN42162', 'LPN45711', 'LPN38754', 'LPN42909', 'LPN42445', 'LPN40755', 'LPN44987', 'LPN44139', 'LPN41866', 'LPN39967', 'LPN30630', 'LPN39418', 'LPN31524', 'LPN47093', 'LPN44571', 'LPN39778', 'LPN33837', 'LPN40556', 'LPN30925', 'LPN46969', 'LPN43602', 'LPN45403', 'LPN37347', 'LPN37251', 'LPN44217', 'LPN31366', 'LPN43632', 'LPN43430', 'LPN31651', 'LPN45094', 'LPN39872', 'LPN40921', 'LPN47103', 'LPN37308', 'LPN46373', 'LPN44955', 'LPN40258', 'LPN43743', 'LPN36770', 'LPN31804', 'LPN44633', 'LPN46987', 'LPN31380', 'LPN42501', 'LPN43432', 'LPN48212', 'LPN37202', 'LPN43198', 'LPN42422', 'LPN42655', 'LPN43523', 'LPN43939', 'LPN30302', 'LPN45952', 'LPN41998','LPN39750', 'LPN39783', 'LPN44788', 'LPN44339', 'LPN47804', 'LPN47856', 'LPN41398', 'LPN40920', 'LPN48003', 'LPN30145', 'LPN45870', 'LPN38272', 'LPN38996', 'LPN40635', 'LPN31596', 'LPN31491', 'LPN44141', 'LPN31259', 'LPN41934', 'LPN48231', 'LPN43857', 'LPN38821', 'LPN46399', 'LPN48093', 'LPN42915', 'LPN43034', 'LPN41326', 'LPN46191', 'LPN47544', 'LPN37209', 'LPN34846', 'LPN30208', 'LPN40340', 'LPN42362', 'LPN30446', 'LPN42497', 'LPN31155', 'LPN47180', 'LPN41571', 'LPN31895', 'LPN37241', 'LPN43276', 'LPN30246', 'LPN48463', 'LPN37905', 'LPN42147', 'LPN42812', 'LPN40662', 'LPN39128', 'LPN44952', 'LPN43863', 'LPN44242', 'LPN43906', 'LPN42093', 'LPN33688', 'LPN41833', 'LPN30036', 'LPN48432', 'LPN39339', 'LPN40840', 'LPN38366', 'LPN46569', 'LPN46511', 'LPN30926', 'LPN42234', 'LPN45671', 'LPN47189', 'LPN39806', '', 'LPN45726', 'LPN44428', 'LPN47385', 'LPN47271', 'LPN41288', 'LPN31372', 'LPN47493', 'LPN44310', 'LPN30749', 'LPN30241', 'LPN44668')
AND wh_Id = '324';