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 DISTINCT e.EmployeeID, es.EmployeeStatus AS Status, e.EmployeeDescNoID AS Emp_Name, e.WindowsUserName AS LoginID, e.DisplayEmployeeID AS UserID, e.ExtNoUD AS Extension, e.FFWMobileUD AS FFWMobile, e.WorkEmail AS Email, -- profitcentre -- department e.EliteNoUD AS SectionNumber, e.SecretaryNameUD AS Secretary, e.LocationUD AS Location, ej.PostID AS Position FROM [Cascade].dbo.Employee e JOIN [Cascade].dbo.EmployeeJobs ej ON e.EmployeeID = ej.EmployeeID JOIN [Cascade].dbo.Employee_Status es ON e.EmployeeID = es.EmployeeID LEFT OUTER JOIN (select t1.JobTitle, t1.EmployeeID from [Cascade].dbo.EmployeeJobs t1 join (select employeeId, min(Sequence) as sequence from [Cascade].dbo.EmployeeJobs group by employeeID ) t2 on t1.employeeid = t2.employeeID and t1.Sequence = t2.Sequence ) ej1 ON e.EmployeeID = ej1.EmployeeID WHERE es.EmployeeStatus = 'Current' --AND (MIN(ej.SEQUENCE))
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.