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

    converting date format

    just need help converting date from yyyymmdd to yyyy-mm-dd so i can compare two fields with different date formats
  2. wizard1923

    Eliminate rows with duplicate values in specific fields

    Perfect! Thank you very much!
  3. wizard1923

    Eliminate rows with duplicate values in specific fields

    Excellent! Thank you very much. However I forgot to include an additional clause in my question. There are numerous records that do not have a control_number or record_type and I want to keep all of these records. i.e. update_datetime control_number record_type 2010-12-29-9.30.10...
  4. wizard1923

    Eliminate rows with duplicate values in specific fields

    newbie with rudimentary knowledge of SQL queries here...trying to eliminate erroneous records with specific criteria. here is what i'm trying to accomplish: select update_datetime ,control_number ,record_type from table1 inner join table2 on table1.field = table2.field where update_datetime...

Part and Inventory Search

Back
Top