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 * INTO ##tblCB From (SELECT * FROM CORE.tblStatusTracking ST WHERE nCaseID IN ( select distinct st.nCaseID, Max(st.dtCreatedDate) from CTS.CORE.tblCase c inner join CTS.CORE.tblStatusTracking st On c.nCaseID = t.nCaseID inner join CTS.CORE.tblCD_AR_CaseInfo ci on c.nCaseID = ci.nCaseID inner join CTSApp.app.tblOracleCustomers oc on ci.sCustID = oc.ACCOUNT_NUMBER where c.nUserID_PrimaryAgent = 5402 and c.bClosed = 0 and CUSTOMER_TYPE = 'NP & SS' group by st.nCaseID) )tt
|SQL Server - Sum Decimal Columns||11||33|
|how to stop adding the same data into my table by using stored precedure in msSql?||5||34|
|SQL 2008 R2 syntax||11||29|
|Is there any way to convert exponential value to number in sql server||5||38|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
9 Experts available now in Live!