We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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
Join the community of 500,000 technology professionals and ask your questions.