title: Adding Row Numbers To a SELECT Query Result in SQL Server Without use Row_Number() function
body: <p>i need Add Row Numbers To a SELECT Query without using Row_Number() function.<br>
  <strike>and without using user defined functions or stored procedures.</strike></p>
  
  <pre><code>Select (obtain the row number) as [Row], field1, field2, fieldn from aTable
  </code></pre>
  
  <p>UPDATE</p>
  
  <p>i am using SAP B1 DIAPI, to make a query , this system does not allow the use of rownumber() function in the select statement. </p>
  
  <p>Bye.</p>