Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.
--UPDATE myTable declare @d1 DATETIME set @d1 = (SELECT CASE WHEN AdjustedHireDate >= StartDate Then AdjustedHireDate else StartDate end FROM myTable) --SET UserDefinedDate1 = DATEADD(YEAR, year(getdate())-year(d1), D1) -- , UserDefinedDate3 = DATEADD(DAY, 60, DATEADD(YEAR, year(getdate())-year(D1), D1)) -- , UserDefinedDate5 = DATEADD(DAY, 180, DATEADD(YEAR, year(getdate())-year(D1), D1)) SELECT SupervisorID , EmployeeID , StartDate , AdjustedHireDate , UserDefinedDate1 , UserDefinedDate2 , UserDefinedDate3 FROM dbo.tblPaEmpGenInfo
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.