USE T202324
insert into t202425.dbo.company_detail select * from company_detail where compcode ='24TR001'


USE T202425
UPDATE CUSTOMER_GROUP_MASTER SET CustFirmCode='24TR001' WHERE CustFirmCode='25TR001'
UPDATE CUSTOMER_MASTER SET CustFirmCode='24TR001' WHERE CustFirmCode='25TR001'
UPDATE SUPPLIER_GROUP_MASTER SET SuppFirmCode='24TR001' WHERE SuppFirmCode='25TR001'
UPDATE SUPPLIER_MASTER SET SuppFirmCode='24TR001' WHERE SuppFirmCode='25TR001'
UPDATE PURCHASE_DETAIL SET CompCode='24TR001', FirmCode='24TR001' WHERE FirmCode='25TR001'
UPDATE PURCHASE_ADDLESS_DETAIL SET CompCode='24TR001' WHERE CompCode='25TR001'
UPDATE PURCHASE_TRANSPORT_DETAIL SET CompCode='24TR001' WHERE CompCode='25TR001'
UPDATE PURCHASE_IMAGES_DETAIL SET FirmCode='24TR001' WHERE FirmCode='25TR001'
UPDATE OPENING_PURCHASE_DETAIL SET CompCode='24TR001', FirmCode='24TR001' WHERE FirmCode='25TR001'
UPDATE OPENING_PURCHASE_ITEM_DETAIL SET CompCode='24TR001' WHERE CompCode='25TR001'
UPDATE OPENING_PURCHASE_ADDLESS_DETAIL SET CompCode='24TR001' WHERE CompCode='25TR001'
UPDATE OPENING_PURCHASE_TRANSPORT_DETAIL SET CompCode='24TR001' WHERE CompCode='25TR001'
UPDATE OPENING_PURCHASE_IMAGES_DETAIL SET FirmCode='24TR001' WHERE FirmCode='25TR001'
UPDATE ORDER_DETAIL  SET CompCode='24TR001' WHERE CompCode='25TR001'
UPDATE ORDER_ITEM_DETAIL  SET CompCode='24TR001' WHERE CompCode='25TR001'
UPDATE PURCHASE_ITEM_DETAIL  SET CompCode='24TR001' WHERE CompCode='25TR001'
UPDATE CHEQUE_RETURN_DETAIL SET CompCode='24TR001', FirmCode='24TR001' WHERE FirmCode='25TR001'
UPDATE CUSTOMER_SUPPLIER_REMARK SET CompCode='24TR001' WHERE CompCode='25TR001'
UPDATE RETURN_GOODS_DETAIL SET CompCode='24TR001',RtnFirmCode='24TR001' WHERE RtnFirmCode='25TR001'
UPDATE RETURN_GOODS_ADDLESS_DETAIL SET CompCode='24TR001' WHERE CompCode='25TR001'
UPDATE RETURN_GOODS_ITEM_DETAIL SET CompCode='24TR001' WHERE CompCode='25TR001'
UPDATE RETURN_GOODS_IMAGES_DETAIL SET RtnFirmCode='24TR001' WHERE RtnFirmCode='25TR001'
UPDATE RECEIVED_DETAIL SET RecFirmCode='24TR001',CompCode='24TR001' WHERE RecFirmCode='25TR001'
UPDATE RECEIVED_ADDLESS_DETAIL SET CompCode='24TR001' WHERE CompCode='25TR001'
UPDATE RECEIVED_PAYMENT_DETAIL SET CompCode='24TR001' WHERE CompCode='25TR001'
UPDATE RECEIVED_IMAGES_DETAIL SET RecFirmCode='24TR001' WHERE RecFirmCode='25TR001'
UPDATE BROKERAGE_DETAIL SET CompCode='24TR001' WHERE CompCode='25TR001'
UPDATE BROKERAGE_ADDLESS_DETAIL SET CompCode='24TR001' WHERE CompCode='25TR001'
UPDATE RETURN_GOODS_DETAIL SET CompCode='24TR001' WHERE CompCode='25TR001'


DELETE FROM COMPANY_DETAIL WHERE CompCode='25TR001'