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!

Register Log in
  • Congratulations Rhinorhino 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: jposner
  • Content: Threads
  • Order by date
  1. jposner

    MIN problem in sub-query

    Hello, I am having problems running the below portion of a query. Any suggestions are greatly appreciated. Ultimately, I am trying to pull the minimum date from a benefit table, where the minimum date is in 2003. It is important to have both parameters because I need to know whether an...
  2. jposner

    datepart function not working properly

    In my query below for terminated employees, I need the datepart function to return terminated employees up to the date entered but only from the year of the date entered. So if a user enters the date 2/1/04 they should see all employees that have terminated in 2004, through Feb. 1st...
  3. jposner

    SQL ODBC failure -Exceed Threshold of 3000 DB error DLL

    OK. I have a report that works fine as is and highlights discrepancies between fields and our 18 digit grant code which is compile fromt he codes (but in not linke din the software and so this is my data validation). I have set-up Crystal alerts to identify onbly the discrepancies, but you...

Part and Inventory Search

Back
Top