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

Recent content by krisav

  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