Looking for a simple way to insert row number information into a Table

• huston.dunlap

  SSCommitted

  Points: 1551

  More actions

  November 16, 2009 at 5:48 pm

  #139449

  I know that the OVER command cannot be used in update statements, which limits my ability to update tables with row number mainpulations.

  Currently I am creating a temp table with a foreign key, and the row number information....and then joining that with the original table with an update statement.

  Is there a cleaner, faster way to accomplish this?

• Paul White

  SSC Guru

  Points: 150467

  More actions

  November 16, 2009 at 6:27 pm

  #1079990

  Could you post what you're using at the moment? It would help to explain what you need.

  Feel free to simplify it down.

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi