Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
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
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!