Displaying serial nos for output rows.

• lucky-80472

  SSCertifiable

  Points: 7793

  More actions

  May 5, 2004 at 10:42 pm

  #163563

  Hi,

  I want to know if there is any possibility to add a column for a dynamically constructed sql query which should show up the serial nos (1 2 3 ..) for the number of rows it displays as output.

  Thanks in advance.

   

  
  Lucky

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  May 6, 2004 at 4:00 am

  #505437

  There is, but....

  It's possible to do it 'on the fly' in a select, but this has serious performance considerations once the underlying data is more than just tiny.

  Another easy workaround is to insert your initial select into a temptable with an identity column, and then select from that.

  Finally, the current 'most fitting all' recommendation is to do the numbering in the client app.

  /Kenneth