Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).
select e.Name_ as [Name],E.Full_Name,count(distinct o.Quote_Number)Q, TotalCount=(SELECT Count(o.quote_Number) FROM SnivalTest_ED..Opportunity o) from SnivalTest_ED..Opportunity o inner join SnivalTest_ED..Employee e on o.Account_Manager_Id = e.Employee_Id inner join SnivalTest_ED..ctLine_of_Business lob on e.Line_of_Business_Id = lob.ctLine_of_Business_Id inner join SnivalTest_ED..ctCompany_Code cc on e.Company_Code_Id = cc.ctCompany_Code_Id inner join @TempListCompanyCode tcc on cc.company_code_name = tcc.CompanyCode inner join @TempListLOB tlob on lob.line_of_business_name = tlob.lob where o.Status = 4 -- Won and e.Name_ = isnull(@Employee, e.Name_) and o.Won_Date >= @STARTDATE and o.Won_Date <= @ENDDATE and ISNULL(o.Completion,0) = 0 AND ISNULL(o.NO_QUOTE___T_AND_M,'0') IN ('No','0') AND ISNULL(o.WARRANTY,'No') = 'No' group by e.Name_,E.Full_Name order by e.Name_
|Temporarily disable SQL Replication||7||21|
|unable to execute Update query in Access 2016 on a table linked to SQL.||5||33|
|Numeric sequence in SQL||14||36|
|Sql query to Stored Procedure||6||14|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!