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 Mike Lewis 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. krisav

    Query shows no results in MSTR but OK against DB

    correction This only thing I am able to see is to make it as to_date('05-jun-03','dd-mon-rr'). The Toad has a setting of RR format i.e anything less that 50 to be considered as 2050.
  2. krisav

    Query shows no results in MSTR but OK against DB

    This only thing I am ale to see the to make it as to_date('05-jun-03','mm/dd/rr'). The Toad has a setting of RR format i.e anything less that 50 to be considered as 2050. -- Krishnan
  3. krisav

    Intelligent Filter

    The joins are formed but it like as under from table1 a11, table2 a12 where a11.load_date = a12.load_date and a11.load_date = filter_value but I want it to be from table1 a11, table2 a12 where a12.load_date = Filter_value and a11.load_date = filter_value -- Krishnan
  4. krisav

    Intelligent Filter

    I have a column 'Load_date' which is available in many tables and it becomes very important filter. My question is how do I create a filter that would be intelligent enough to include that many where clauses as many table in the from clauses. For example if in From clause I have Table1, table2...

Part and Inventory Search

Back
Top