title: MSSQL Select statement with incremental integer column... not from a table
body: <p>I need, if possible, a t-sql query that, returning the values from an arbitrary table, also returns a incremental integer column with value = 1 for the first row, 2 for the second, and so on.</p>
  
  <p>This column does not actually resides in any table, and must be strictly incremental, because the ORDER BY clause could sort the rows of the table and I want the incremental row in perfect shape always...</p>
  
  <p>Thanks in advance.</p>
  
  <p>--EDIT
  Sorry, forgot to mention, must run on SQL Server 2000</p>