With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
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 ) ej ON e.EmployeeID = ej.EmployeeID WHERE es.EmployeeStatus = 'Current'
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!