Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
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'
|I Need a T-SQL Query (Union or Intersect, or...?)||6||38|
|MS SQL with ODBC||5||34|
|What's wrong with this T-SQL Foreign Key?||7||38|
|Connecting to multiple databases to create a Dashboard||5||21|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!