replace values of rows and update with preset value

• musasuleman

  Old Hand

  Points: 300

  More actions

  July 24, 2009 at 5:29 am

  #223885

  I need an sql Update command that will arrange row to be serially arrange from a value I am specifying (13108 to X) the end of the last row(where x is the last value .

  Can any one help please?

  the rows already have value from 1 to 1500, so I need to update the value to be from 13108 to the last value.

  The table name is called scoretable while the row the value is called sore_id.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  July 24, 2009 at 6:02 am

  #1029579

  I'm unable to understand your needs, please specify:

  1) DDL for the tables involved

  2) Sample data

  3) What you have coded so far

  Read this article for more info on how effectively post your questions:

  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  Regards

  Gianluca

  -- Gianluca Sartori

• Lamprey13

  SSCertifiable

  Points: 6210

  More actions

  July 24, 2009 at 2:13 pm

  #1030044

  UPDATE ScoreTable

  SET sore_id = sore_id + 13107