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