Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
Select ctName, C.catName, Q.qryNo, actQryNo, qryAccNo, qryNasRefNo, qryAllocDept, Department_name, qryLogDept, qryAllocText, qryFinalText, qrySource, qryMethod, qryStatus, E.Surname + ' '+ E.First_Name as Employee,actUser, Q.qryLogTime, A.actTime, actKey From CTS..Queries Q inner join (select Max(actKey) as MaxKey ,actQryNo as MaxactQryNo from Actions group by actQryNo) as MaxAction on MaxAction.MaxactQryNo = Q.QryNo inner join Actions A on MaxAction.MaxKey = A.actKey inner Join CTS..CallType_Category_Links L on L.ccID = Q.qryCallTypeCategory inner Join CTS..Categories C on C.catID = L.Category inner Join CTS..CallTypes T on T.ctKey = L.CallType inner Join CTS..Customers Cus on Cus.cstAccNo = Q.qryAccNo Inner Join SYS04_Frontier..Frontier_sys04_Employees E on E.Logon_Name = Q.qryAllocUser Inner join SYS04_Frontier..Frontier_sys04_DEPARTMENTS D on D.ID = Q.qryAllocDept Where ctName in('Branch Banking Existing Business', 'Branch Banking New Business') and Q.qryStatus IN('Pending','Unresolved') Order by actQryNo
|SQL Script to pefrom an insert and update activity on 2 different tables at the same time||9||69|
|SQL Server pivot on DateAdded||2||24|
|Insert statement is inserting duplicate records||15||47|
|Sql Data via Excel--performance issues||2||39|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!