Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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.
|push and Pull replication||31||48|
|SQL Sum of items in two tables not equal.||5||49|
|Example to create one row of data from multiple rows and have multiple columns,||12||29|
|What Is an Error?||2||27|