Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- E.FirstName ,
- E.LastName ,
- SR.DateFrom,
- AD.AdditionDeductionNr,
- AD.Code
- FROM
- dbo.Employe_Employes E
- INNER JOIN StaffSalary_Registers SR ON SR.EmployeeNr = E.EmployeNr
- INNER JOIN StaffSalary_RegisterValues RV on RV.RegisterNr = sr.RegisterNr
- INNER JOIN StaffSalary_AdditionsDeductions AD ON AD.AdditionDeductionNr = RV.AdditionDeductionNr
- WHERE
- SA.AdditionDeductionNr = @AdditionDeductionsNr
- AND SR.DateFrom = @monthNo
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement