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 IamaSherpa 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: oda10
  • Order by date
  1. oda10

    Difficult SQL query

    Hi! Thanks a lot, it seems to work fine. It's not that slow and it dosn't matter that much since the query is only going to be run at night once a month. Now I just have to put this query into a much bigger one.... Thanks again! /Fredrik
  2. oda10

    Difficult SQL query

    Hi Marc! Yes, it is correct that I can have duplicate rows for the period but one row has TYP=T and the other one is blank. Then the row with the T should be returned. Only spaces and T's is in the column TYP. There are never similar periods and identical TYP. /Fredrik
  3. oda10

    Difficult SQL query

    Hi! I have this table: IDNR FOM TYP TOM 1000 2003-mar-31 1000 2003-mar-31 T 2003-apr-30 1000 2003-feb-11 2003-mar-30 1010 2003-mar-31 1020 2003-mar-31 T 2003-apr-30 1020 2003-mar-31 2003-apr-30 1030 2003-mar-31 1030 2003-feb-11 2003-apr-30 If I...

Part and Inventory Search

Back
Top