Updating every second or third row

[seosamh]

I need to update every second or third row in a table. There is very little to differentiate particular rows, so manually updating them is not really an option. [sig][/sig]

 

[ColinM]

Add an extra column (ID) with an identity starting at 1
Then you can do use the modulo function (%) to get every other row:
SELECT * FROM TABLE WHERE (ID % 2) = 0
[sig][/sig]