Group, I recently had a case where I needed to evaluate my need to use cursors. So I thought I would examine the help document on speeding up.
Frequently I need to update columns in one table based on values in another. The really fast way to accomplish this is using something like this. UPDATE table1 SET + column1 = column1, + column2 = column2, + column3 = column3 + FROM table2,table1 + WHERE table1.commoncolumn = table2.commoncolumn Sometimes we need a little push so I would encourage to explore other ways of doing things. Jan
