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 Rhinorhino 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 philsivyer

  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

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

    Just like to say thanks for the response and will try your suggestion - I already had one reply to my query as per below and know this works. SELECT MyTable.* FROM MyTable LEFT JOIN (SELECT Oc_Id, Customer_Id FROM MyTable WHERE Expire_Date > GETDATE()) Tbl1 ON...
  3. philsivyer

    Excluding data in groups when met by a condition

    BRILLIANT!! Many thanks
  4. philsivyer

    Excluding data in groups when met by a condition

    Thanks - but not the solution - probably my poor attempt to explain the problem. I do not want to select just oc_id = 10 .... there will be thousands of oc_ids but I only want oc_ids (this is a type of journal by the way) and within each group of journals there will be customers (customer_id)...
  5. 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...
  6. 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...
See more

Part and Inventory Search

Back
Top