Datanory Production » Datanory - DAILYFRESH

Requested user to upload database for further checking

select * from customer where customer_code= 'ASCS1208'
select * from customer where customer_name like '%warisan infak%'
-- I notice there is 1

select * from customer_to_user_relation where customer_id= '83365ef6-8527-4af0-8e39-94e7c76a06b1'-- D''PUTRA MART
   select * from member where   member_id= '0E40E164-1372-433B-8227-60C44DBAD7A0'
    select * from member where   member_id= 'ECD07AEB-D7FF-4A18-90A0-A12A3F8B3824'

select * from customer_to_user_relation where customer_id= '461a2c9e-180d-4ade-86a4-b5fe933bad80'-- warisan infak

select * from member where org_id= 'A000003' and member_cd='admin'
     select * from member where   member_id= 'ECD07AEB-D7FF-4A18-90A0-A12A3F8B3824'
select * from mst_route where org_id= 'A000003' and member_id= '0E40E164-1372-433B-8227-60C44DBAD7A0' and month= 5 and customer_id= '83365ef6-8527-4af0-8e39-94e7c76a06b1'  

select * from mst_route where org_id= 'A000003' and member_id= '0E40E164-1372-433B-8227-60C44DBAD7A0' and month= 5 and customer_id= '461a2c9e-180d-4ade-86a4-b5fe933bad80'

Hi Technical Team. Why the same cstmr double for tomorrow? As per last week.

Same cstmr. AST17

https://app.clickup.com/t/86epfkf1r

Delete from mst_route where route_summary_id in(
select route_summary_id from (
select route_summary_id,customer_id,member_id,date,org_id,
ROW_NUMBER() over (partition by customer_id,member_id,date,org_id order by date)rn
from mst_route with (nolock) where org_id='A000003'
)x where rn<>1
)

select * into DMS_Ecosystem_Backup_Table.dbo._mst_route_20240529
from DMS_EcoSystem.dbo.mst_route