4Hero

demo@4hero.pl Układ Resetuj

Edycja statusu

Kolor
Zapytanie SQL ( select cus.Cus_Id FROM [ORG].[Customer] cus with (NOLOCK) where cus.Cus_CustomerStatusId not in (7,8,9,10,11)and (select count(*) from [ORG].DocumentHeader dh with (NOLOCK) where cus.Cus_Id = dh.Doh_BuyerCustomerId and dh.Doh_DocumentTypeId = 1 )=0 and (select count(*) from (select l.Lea_Id from ERP.Lead l with (NOLOCK) left outer join ERP.LeadStageSalesType lsst with (NOLOCK) on lsst.Sst_Id = l.Lea_LeadStageSalesTypeId left outer join ERP.LeadStage ls with (NOLOCK) on ls.Lst_Id= lsst.Sst_LeadStageId where cus.Cus_Id = l.Lea_CustomerId and ls.Lst_Final=0 and l.Lea_FiascoId is null group by l.Lea_Id) as b) >0 group by cus.Cus_Id )
Priorytet
Powód zmiany statusu

Obecnie pracujesz na demo. Zacznij bezpłatny okres testowy na online.4hero.pl