"For Each" is always best avoided, think set based! Might be better if you
could forward your SQL.
Rhys
-Original Message-
From: Neil Tompkins [mailto:[EMAIL PROTECTED]
Sent: 04 October 2007 12:19
To: My SQL
Subject: Speeding Up Process
Hi
I've the following process/
Hi
I've the following process/queries which I want to speed up, for a product
inventory/warehouse which we have a number of items available to sell each day
For Each Company
For Each Product
For Next 7 Days
CheckQuantityUpdateQuantity
Next Day
Next Product
Nex