generating sequential number in sql 2000

• Abhijit More

  SSCertifiable

  Points: 6897

  More actions

  February 21, 2011 at 6:20 am

  #234802

  I have one requirement where i need to generate the sequential numbers for group of data in Single Query.

  How can i do it in SQL server 2000?

  Abhijit - http://abhijitmore.wordpress.com

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  February 21, 2011 at 6:23 am

  #1289400

  I suppose you mean a replacement for ROW_NUMBER function in SQL 2000, right?

  -- Gianluca Sartori