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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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 -
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 -
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...
