Datanory Production » Datanory - SUNTORY

select * from txn_sales_order_header
where order_no like 'SOSR0300035[2-9]-240626' or order_no like 'SOSR0300036[0-8]-240626'

select * from txn_sales_order_approval_history a
inner join txn_sales_order_header b on b.ord_hdr_id = a.order_id and b.org_id = 'KYMMSENG'
where b.order_no like 'SOSR0300035[2-9]-240626' or b.order_no like 'SOSR0300036[0-8]-240626'

--select * into _txn_sales_order_header_20240626 from txn_sales_order_header
--select * into _txn_sales_order_approval_history_20240626 from txn_sales_order_approval_history

--update txn_sales_order_header set order_status = 'Pending', status = 'Pending', updated_date = getdate(), updated_by = 'Support'
--where order_no like 'SOSR0300035[2-9]-240626' or order_no like 'SOSR0300036[0-8]-240626'

--update a set a.status = 'Pending', a.status_date = getdate(), a.updated_date = getdate(), a.updated_by = 'Support'
--from txn_sales_order_approval_history a
--inner join txn_sales_order_header b on b.ord_hdr_id = a.order_id and b.org_id = 'KYMMSENG'
--where b.order_no like 'SOSR0300035[2-9]-240626' or b.order_no like 'SOSR0300036[0-8]-240626'

update a set a.approval_type = 'Y'
FROM txn_sales_order_approval_history a
WHERE a.order_id IN
(
'019542c8-ca85-4ada-a4bb-d0e3d04578f6',
'104ed69e-7987-47b1-a58a-66ffab230d4d',
'26b4d607-76ed-4e0d-a46e-7d2ab990b8f6',
'2acf188e-5153-48d4-b53b-6162b100d4ac',
'3bd9cbc5-6612-46b4-93f4-161faeee67f8',
'3f23640b-4650-499c-82bd-9da40b179766',
'48b02966-d75a-4681-b028-7c89b36680ad',
'4c5a5e0f-e0eb-4acd-9157-e3f6274dbaad',
'58ecbb78-d438-4b14-98aa-aa443dbd0243',
'670fe54d-5ac6-4381-a113-80232a15a502',
'93d9b643-0905-4f6b-a08c-a18a45f944a3',
'afc902d6-78de-4461-80fb-4791c4ca479c',
'b8308a4d-67a4-4d6e-864d-34ef27c0f907',
'bc10378c-1855-46ac-a29a-afa28851891f',
'c3dd6045-6abf-4194-8add-cfffdafb5948',
'f0d0eda4-90d1-4171-ac44-e69189f6bd99',
'fbb17779-c998-4b62-846c-dd58087dc36d'
)