Cek branch tidak match
Update KYZN BSD
branch != 'KYZN BSD'
select * from public.leads
where
assigned_pic IN (
'Tegar',
'Ananda',
'Annisa',
'Raditya',
'Mulyadi',
'Dhita',
'Dimas',
'Seyla',
'Nesni',
'Desra',
'Sarah Tika',
'Ayu',
'Endah',
'Munajar',
'Roy',
'Zain'
) AND branch != 'KYZN BSD'
update branch != 'KYZN BSD'
update public.leads
set
branch = 'KYZN BSD'
where
assigned_pic IN (
'Tegar',
'Ananda',
'Annisa',
'Raditya',
'Mulyadi',
'Dhita',
'Dimas',
'Seyla',
'Nesni',
'Desra',
'Sarah Tika',
'Ayu',
'Endah',
'Munajar',
'Roy',
'Zain'
) AND branch != 'KYZN BSD'
Update KYZN Kuningan
branch != 'KYZN Kuningan'
select * from public.leads
where
assigned_pic IN (
'Usep',
'Dede',
'Nicolaas',
'Regi',
'Reinaldy',
'Nisha',
'Reza',
'Riandaud',
'Farhan',
'Indah',
'Jehan',
'Delfi',
'Erika',
'Rastika',
'Richard',
'Ibra',
'Rani',
'Yovita',
'Ulfa'
) AND branch != 'KYZN Kuningan'
update branch != 'KYZN Kuningan'
update public.leads
set
branch = 'KYZN Kuningan'
where
assigned_pic IN (
'Usep',
'Dede',
'Nicolaas',
'Regi',
'Reinaldy',
'Nisha',
'Reza',
'Riandaud',
'Farhan',
'Indah',
'Jehan',
'Delfi',
'Erika',
'Rastika',
'Richard',
'Ibra',
'Rani',
'Yovita',
'Ulfa'
) AND branch != 'KYZN Kuningan'
Last updated