Datanory Production » Datanory - GOLDCREST

Hi, can help to set branch code also?

select b.branch_code, * from mst_area a
inner join mst_branch b on b.branch_id = a.branch_id
where a.org_id = 'goldcrest'

select * from mst_branch where org_id = 'goldcrest' and branch_id not in (select branch_id from mst_area where org_id = 'goldcrest')

select * from customer where org_id = 'goldcrest' and updated_by = 'Support' order by updated_date desc

--select * into DMS_Ecosystem_Backup_Table.dbo._customer_20240525
--from DMS_EcoSystem.dbo.customer

select b.area_code, c.branch_code, a.branch_id, b.branch_id, * from customer a
inner join mst_area b on b.area_id = a.area_id and b.branch_id <> a.branch_id
inner join mst_branch c on c.branch_id = a.branch_id
where a.org_id = 'goldcrest'

--update a set a.branch_id = b.branch_id, a.updated_by = 'Support', a.updated_date = GETDATE
--from customer a
--inner join mst_area b on b.area_id = a.area_id and b.branch_id <> a.branch_id
--inner join mst_branch c on c.branch_id = a.branch_id
--where a.org_id = 'goldcrest'

select * from mst_customer_branch where org_id = 'goldcrest' and updated_by = 'Support' order by updated_date desc

--select * into DMS_Ecosystem_Backup_Table.dbo._mst_customer_branch_20240525
--from DMS_EcoSystem.dbo.mst_customer_branch

select a.branch_id, b.branch_id, * from mst_customer_branch a
inner join customer b on b.customer_id = a.customer_id --and b.branch_id <> a.branch_id
where a.org_id = 'goldcrest'

--update a set a.branch_id = b.branch_id, a.updated_by = 'Support', a.updated_date = GETDATE
--from mst_customer_branch a
--inner join customer b on b.customer_id = a.customer_id and b.branch_id <> a.branch_id
--where a.org_id = 'goldcrest'

- end shift.
- handover to arif.
- this ticket already done. just need to inform user.