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 bkrike 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: philsivyer
  • Content: Threads
  • Order by date
  1. philsivyer

    Grouping dilema

    Best shown as an example .. table_1 type cust_id order_no seq expire_date print_online 4 1234 a5432 1 01/01/07 null 0 1234 a5432 2 02_04_07 print 0 1234 a5432 3 03/04/07 online 1 1234 a5432 4 03/04/07...
  2. philsivyer

    Excluding data in groups when met by a condition

    Example...... initial data set oc_id customer_id order_no expire_date 10 001 0123 01/01/2004 10 001 0124 01/01/2005 10 001 0125 01/01/2006 11 002 4567 01/01/2005 11 002 6789 01/01/2007...
  3. philsivyer

    Returning data only with date field <= today - using groups

    Example...... initial data set oc_id customer_id order_no expire_date 10 001 0123 01/01/2004 10 001 0124 01/01/2005 10 001 0125 01/01/2006 11 002 4567 01/01/2005 11 002 6789 01/01/2007...

Part and Inventory Search

Back
Top