Hey Thankx A TON!

I shall test this code out tomorrow morning ie abt 10 hrs from now! and get back to you.

I shall try and get the other part of the code rectified on the similar lines!

Thankx!

quote:

---

And before anyone points it out, I'd like to state that I deliberately LEFT OUT transactions from the procedure I posted to give some weight to the fact that the original procedure would have left records orphaned if it had failed within the cursor, since there was no transaction started before the cursor began. Cheers.

---

Mumbai, India