Thanks for the suggestion.  Unfortunately I haven't written anything in 2005, so I wouldn't know where to start.  One interesting thing I've found is that I can return up to...

Thanks for the help all...I finally got a good result.  Charles, your suggestion helped.  I passed both count statements via the method you suggested and that allowed the query to...

Scan

There is a clustered index on the cartons table which seems to be sucking up the most processing time, i.e., 33% each time.

I'm still struggling with this same issue, so I'm going try try and provide a bit more information if anyone can help me out.  Below is my query minus the container...

Thanks for the suggestion Charles.  I'm running your query now and it is at around 22 minutes and counting.  The problem started when I added the count(distinct(carton_no), but I don't...

David, the two dateadd statements are to make certain we are only getting data from yesterday (there may be a better way to do it).  Because...