I think you have that backwards. If there is no loop, then a do will suffice. If you have a loop, then do the prepare before going into the loop, and (obviously) the execute inside. So you save on the prepare step.OK... From what I have read, the "prepare...execute" method is no more acceptable than the "do" method. My understanding is that if you are going to be inserting multiple instances, without looping, then you are better served with using the "prepare...execute" method. If you are looping through data, then using the "do" method is no worse. I am going to create a copy using the "prepare...execute" method exclusively, and time that against the existing version. This will give me very real world comparison. Thanks for the feedback again.
Scott Nipp
Someone correct me if I am worng, but this is how I have always understood it.
Chris
-- ------------------------------- Just Your Friendly Neighborhood _SPIDEY_
-----------------------------------------
The information contained in this message may be privileged, confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or any employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer.
Thank you. Paychex, Inc.
