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 TouchToneTommy 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: *

  1. HRISCONSULTANT

    Saving reports with > 32K records as .CSV

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

    Pulling the top 2 rows as well as New Hires on a table...

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

    Pulling the top 2 rows as well as New Hires on a table...

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

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

Part and Inventory Search

Back
Top