I need to find the most efficient way of updating records on mass. What I am trying to achieve is to update records in a table that meet a certain criteria. The table is linked to a sharepoint 2010 list (but this shouldn't make any difference (I hope))
The fields involved are as follows:
Table = “Newsletter”
Field to update = “Uploaded” (a Yes/No field)
Criteria Field = “Story Type” (Text) - where <> “The Ending”
So the statement would be to mark “Uploaded” as Yes except if Story Type = “The Ending”
The table will grow on average by 2,000 records a year, but each time this code is run there is likely to only be 30-40 records that need updating.
Can anybody help?