I have 2 tables. They share a key. I need to change the value of a column in Table2 depending if a row with that key exists in Table1. I was thinking to use Declare Cursor, with a Fetch in a While loop, but in the back of my brain I seem to remember reading that that was no longer the best way to do it?? Maybe just my imagination but I thought I would ask, just in case a better method existed,
Lin
