Search results for query: *

To date, my experience has been that all formats have hit the 32,000 record limit when exporting the data from a program. So far, only SQR's created on onsite EHRMS systems has allowed me to retrieve a file any bigger than 32,000 rows - if the apllication is hosted, I've always had to limit the...

Thanks Charles, thanks Christine :)

This is not pulling the single row records and is not creating an error... (SELECT MAX(A.EFFDT) FROM PS_JOB A WHERE A.EMPLID = JOB.EMPLID AND A.EFFDT < JOB.EFFDT) where Job is the first ps_job and Job1 is the second ps_job As for stating that null is a possibility, I attempted to cover that...

Basically, the program is to return the last two rows for a report. It is working fine for all but new hires and conversions where there is only one record - at that point nothing is returned. In attempting to use the CASE statement is not quite correct as the error messages noted in the...

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...