Jocem, I store the non-business days because those days are far fewer. I am also using SQL 2000.
Ian, I need to get products that display the sales growth for at least 5 days. If the sales of Listerine exceed the previous days high for 34 days, then I need to return listerine and 34 days. Something like a count(*). Everyone, PS I didn't even add in the craziest part of back trending. Return product,start date of sales growth, end date of sales growth, and length of trend for all products. IE if Doritos had 13 days of sales growth in Jan 1, 2002 to Jan 14, 2004 [no holidays]. If I didn't have to return the number of days the growth occurs, this would be a lot easier. Mostly SQL solution is most desirable. CF solution to count days is slow. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:149725 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=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
