Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
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_
|SQL Server - TSQL - Removing duplicates/How to get max records per id||13||45|
|Is there a better way to combine two queries||7||26|
|Error when creating an UPDATE Trigger in SQL||6||19|
|How would you modify the following SQL Server 2008 stored procedure to prevent it's execution if the value being inserted into the field "BRANCH" is a duplicate ? Branch is the Primary Key.||2||17|