Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: HRISCONSULTANT
- Content: Threads
- Order by date
-
Pulling the top 2 rows as well as New Hires on a table...
A user is getting expected results with the following... (SELECT MAX(A.EFFDT) FROM PS_JOB A WHERE A.EMPLID = JOB.EMPLID AND A.EFFDT < JOB.EFFDT) Job is the first ps_job Job1 is the second ps_job There is a problem however when there is a new hire or conversion (no records returned). I've...- HRISCONSULTANT
- Thread
- Replies: 10
- Forum: Strategic Reporting Systems(SRS): ReportSmith
