daily pastebin goal
37%
SHARE
TWEET

Untitled

a guest Jun 19th, 2017 47 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.     E.FirstName ,
  3.     E.LastName ,
  4.     SR.DateFrom,
  5.     AD.AdditionDeductionNr,
  6.     AD.Code
  7. FROM
  8.     dbo.Employe_Employes E
  9. INNER JOIN StaffSalary_Registers SR ON SR.EmployeeNr = E.EmployeNr
  10. INNER JOIN StaffSalary_RegisterValues RV on RV.RegisterNr = sr.RegisterNr
  11. INNER JOIN StaffSalary_AdditionsDeductions AD ON AD.AdditionDeductionNr = RV.AdditionDeductionNr     
  12. WHERE
  13.     SA.AdditionDeductionNr = @AdditionDeductionsNr
  14.     AND SR.DateFrom =  @monthNo
RAW Paste Data
Top