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

    MIN problem in sub-query

    Thanks SQLBill. Actually that suggestion would only return the minimum value that is greater than Jan. 1, 2003. I needed to return the minimum value for someone whose minimum value is at least Jan. 1, 2003. So if they had a record in 2002 and 2003, I don't want that on the report at all...
  2. jposner

    MIN problem in sub-query

    here is the entire query. I didn't want to paste all this if the issue was just with the subquery. SELECT EBase."EbSocNumber", EBase."EbFirstName", EBase."EbLastName", EBenefit."EnDateBeg", EBenefit."EnDateEnd", EBenefit."EnEECostPerPay", EBenefit."EnERCostPerPay", BenBase."BbDescrip"...
  3. jposner

    MIN problem in sub-query

    when I try: and (ebenefit.endatebeg =(SELECT Min(eb1.endatebeg) FROM ebenefit as eb1 GROUP BY endatebeg HAVING Min(eb1.endatebeg) >= '1/1/2003')) I am told that the subquery is returning more than 1 value which is not allowed. If it's selecting the minimum date where the minimum date...
  4. jposner

    MIN problem in sub-query

    oops. sorry, here is the whole piece: ...and(ebenefit.endatebeg = (select min(eb1.endatebeg) from ebenefit as eb1 where eb1.enflxideb = ebase.ebflxid and min(eb1.endatebeg) >= '01/01/2003')) I have the min in both the select and the where which I dont think can happen, but amn not sure of the...
  5. 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...
  6. jposner

    datepart function not working properly

    THANKS!! worked perfect
  7. 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...
  8. jposner

    SQL ODBC failure -Exceed Threshold of 3000 DB error DLL

    Hi Ito, That's what I figured. I can't create Views because this is linked to my HRIS. I do not have the ability to generate views in the typical manner one would in an Access DB or a SQL Server (though this is a SQL Server DB, but it is hosted by our vendor and I cannot even establish an ODBC...
  9. jposner

    SQL ODBC failure -Exceed Threshold of 3000 DB error DLL

    Thanks Ido. I made the correction to where I dropped off the table name prefix and shortened the table name (though it was about 2700 characters before and still didn't exceed 3000) but am still told it will exceed the threshold. Synapsevampire, I am not very familiar with creating views within...
  10. 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