a guest Jul 12th, 2018 52 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- select hrss.salaryScheduleCode, hrss.salaryScheduleName, st.stepName, st.seq, sl.laneName
- from dbo.HRSalarySchedule hrss
- left join dbo.HRSalaryScheduleStep st on st.hrSalaryScheduleID = hrss.hrSalaryScheduleID
- left join dbo.HRSalaryScheduleLane sl on sl.hrSalaryScheduleID = hrss.hrSalaryScheduleID
- order by hrss.salaryScheduleCode, st.seq, sl.seq
RAW Paste Data