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 AND dh.Doh_IssueDate<dateadd(month,-1*12,CURRENT_TIMESTAMP) )>0 and (select count(*) from [ORG].DocumentHeader dh with (NOLOCK) where cus.Cus_Id = dh.Doh_BuyerCustomerId and dh.Doh_DocumentTypeId = 1 AND dh.Doh_IssueDate>=dateadd(month,-1*12,CURRENT_TIMESTAMP) )=0 )
Priorytet
Powód zmiany statusu

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