won lee wrote: > > Sales > ======== > SalesID (PK) > productID (FK) > SalesDate > NumSales
If you have a table that lists the legit business days instead of one with the non-legit days it is quite easy. Just give all the days in that table a sequential number and you get a simple, though somewhat large, 5-fold self-join on day=day+1: SELECT s1.productID FROM Sales s1, Sales s2, Sales s3, Sales s4, Sales s5, BusinessDays d1, BusinessDays d2, BusinessDays d3, BusinessDays d4, BusinessDays d5 WHERE s1.SalesDate = CURRENT_DATE AND s1.productID = s2.productID AND s2.productID = s3.productID AND s3.productID = s4.productID AND s4.productID = s5.productID AND s1.salesDate = d1.dayDate AND s2.salesDate = d2.dayDate AND s3.salesDate = d3.dayDate AND s4.salesDate = d4.dayDate AND s5.salesDate = d5.dayDate AND s1.NumSales > s2.NumSales AND s2.NumSales > s3.NumSales AND s3.NumSales > s4.NumSales AND s4.NumSales > s5.NumSales AND d1.dayNumber = d2.dayNumber + 1 AND d2.dayNumber = d3.dayNumber + 1 AND d3.dayNumber = d4.dayNumber + 1 AND d4.dayNumber = d5.dayNumber + 1 Which database are you using? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:149712 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
