Hi, I need to update certain records in a table. The table has several thousand rows, and I have a list of several hundred record numbers. I need to loop through the table and change any records which have a record number equal to one in my list.
record number | value
12 | 45
13 | 46
14 | 47
15 | 48
16 | 49
i.e. I would want to loop through and change records 12,15 & 16 all to have a value of 10.
I have tried several things but they either fall over or create a never ending loop...
Yes its just "select * from tableX", the output is a little more complicated than what I said, but I didnt want to complicate the issue. My problem is having such a large list of record numbers that need to be updated. They are stored in an excel table - is there any way I can load these into some sort of array and then update where a record number is in the array...?