"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:neildtompkins@stripped]
Sent: 04 October 2007 12:19
To: My SQL
Subject: Speeding Up 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
CheckQuantity UpdateQuantity
Next Day
Next Product
Next Company
Is it possible to re-write this routine so that it executes quicker ?
Thanks,Neil
_________________________________________________________________
Get free emoticon packs and customisation from Windows Live.
http://www.pimpmylive.co.uk
This email is confidential and may also be privileged. If you are not the intended
recipient please notify us immediately by telephoning +44 (0)20 7452 5300 or email
postmaster@stripped. You should not copy it or use it for any purpose nor disclose
its contents to any other person. Touch Local cannot accept liability for statements made
which are clearly the sender's own and are not made on behalf of the firm.
Touch Local Limited
Registered Number: 2885607
VAT Number: GB896112114
Cardinal Tower, 12 Farringdon Road, London EC1M 3NN
+44 (0)20 7452 5300
