Update Depending on RowID Value

• AndrewSQLDBA

  SSC-Insane

  Points: 21827

  More actions

  December 30, 2010 at 9:40 am

  #232410

  Hello Everyone

  I am working on an Update statement. That will update a bit column only if the RowID is an Odd number. The RowID is a numeric value starting at number 1 and going thru say 100

  My question is this:

  How can I determine if the RowID is an Even or Odd number?

  I can do this update a different way, but I am trying to learn how to do it using the RowID value

  Thanks in advance

  Andrew SQLDBA

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  December 30, 2010 at 9:44 am

  #1267764

  use the modulus operator (%)

  So if X%2 = 0 then even if X%2=1 then odd

  ---

  
  Clear Sky SQL
  My Blog[/url]

• Cadavre

  SSC-Forever

  Points: 41690

  More actions

  December 30, 2010 at 9:46 am

  #1267766

  UPDATE mytable

  SET column1 = 'test'

  WHERE ABS(myid) % 2 = 1

  Seems Dave was quicker off the draw than me 😉

  ---

  Forever trying to learn
  My blog - http://www.cadavre.co.uk/
  For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
  For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  ---

• AndrewSQLDBA

  SSC-Insane

  Points: 21827

  More actions

  December 30, 2010 at 10:10 am

  #1267777

  Thanks Guys

  That worked perfectly. I don't know why I did not think of using that. Maybe I am getting too old for this.

  Andrew SQLDBA