Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Which brings back records for the last weeks pay. The problem I have is if the employee has been on shifts or overtime then it brings back several records as the PayEmployeePayCodes table has a record for each shift and hours worked on that shift.
SELECT PayEmployeeMaster.PayrollPeriod, PayEmployeeMaster.EmployeeNumber, PayEmployeeMaster.PeriodGrossPay, PayEmployeeMaster.PeriodEmployersNI, PayEmployeeMaster.BasicSalary, PayEmployeePayCodes.PayCode, PayEmployeePayCodes.InputValue, PayEmployeePayCodes.PeriodRateUsed, TimGEEmployeeDetails.Title, TimGEEmployeeDetails.Forename, TimGEEmployeeDetails.Surname, PayEmployeePensionScheme.CurrEmployerAmount, PayEmployeePayCodes.CodeType FROM PayEmployeeMaster INNER JOIN TimGEEmployeeDetails ON PayEmployeeMaster.EmployeeNumber = TimGEEmployeeDetails.EmployeeNumber LEFT OUTER JOIN PayEmployeePayCodes ON PayEmployeeMaster.PayrollPeriod = PayEmployeePayCodes.PayrollPeriod AND PayEmployeeMaster.EmployeeNumber = PayEmployeePayCodes.EmployeeNumber LEFT OUTER JOIN PayEmployeePensionScheme ON PayEmployeeMaster.EmployeeNumber = PayEmployeePensionScheme.EmployeeNumber AND PayEmployeeMaster.PayrollPeriod = PayEmployeePensionScheme.PayrollYearPeriod WHERE (PayEmployeeMaster.PayrollPeriod = 201543) AND (PayEmployeeMaster.EmployeeNumber = '3164') AND (PayEmployeePayCodes.InputValue > 0)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|I would like to delete a cell in excel from which I think it has no use||2||33|
|How to transfer values from one userform in excel to another||14||43|
|Paste Table from Excel VBA to the PowerPoint 2010||18||57|
|3,000 rows of comma separated values||14||31|
Join the community of 500,000 technology professionals and ask your questions.