SQL Question

Quote:

---

Why would you need more than one cursor?

---

You are correct Sir, and I was wrong. It can be done with one cursor. I let a COBOL approach get in the way of thinking this out better. The COBOL approach has you opening two files, reading a record from each, doing the comparison, altering the master record if needed, using a loop (reading the next temp record, etc.). That's where the idea of two cursors came from. Oops. And I was on such a good roll of not putting my foot in my mouth.

Thanks all & especially Jurij Modic ..Yes, I have a PK on the master table. Your approach work perfectly fine .It was very simple & fast.

SQL also worked but it took its own sweet time to complete ...unless I fine tune my other objects this wouldn't work properly.


Quick thinking !!! thank you for your help.

Last word to stecal, I just asked an approach not for an solution ..so I din't post all the details as a developer you may want