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 strongm 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. anniecoops

    View - Average case counts last 12 times on promotion

    Hi, I am setting up a database in a chicken factory. I need to find an average case count of the the last 12 times a product was sold to a particular customer on every day of week. The following works but takes 1 min 15 secs, please help me to simplify. ta heaps, x SELECT custId, ProdId...
  2. anniecoops

    Find last time on promotion based on criteria

    I work on database in chicken factory….involved in predicting stock, promotions etc. Please help, the following code picks up on records where the product is on promotion sometime in the future, i.e. not have any casesSold yet…….. id cust cases birds prod estPromoCase dateOfOrder 670 70260...
  3. anniecoops

    I work on database in chicken facto

    I work on database in chicken factory….involved in predicting stock, promotions etc. Please help, the following code picks up on records where the product is on promotion sometime in the future, i.e. not have any casesSold yet…….. id cust cases birds prod estPromoCase dateOfOrder 670 70260...
  4. anniecoops

    View - Last 12 Times On Promo - Averages

    Hi, I am setting up a database in a chicken factory. I need to find an average case count of the the last 12 times a product was sold to a particular customer on every day of week. The following works but takes 1 min 15 secs, please help me to simplify. ta heaps, x SELECT custId, ProdId...

Part and Inventory Search

Back
Top