Selecting the Row Numbers from a table in a query

• Michael Brennan-White

  Grasshopper

  Points: 23

  More actions

  October 15, 2004 at 8:47 am

  #84472

  Hi,

  I am accessing a table in a SQL Server 2k database that does not have a Unique Key Value for each record. Boo Hiss. I will not be able to change that.

  Is there a way to select the Row Number from the table in the following manner where recno is assumed to be the row number value

  Select recno, transactionid, trandate, status from mytable

  I will be running this query as part of a VFP Cursor Adapter which is blowing up because I don't have a unique value. The values in this cursor will be changed similar to:

  Update mytable set status = newvalue where recno =

  Thank you in advance for your assistance,

  Michael

• David.Poole

  SSC Guru

  Points: 76001

  More actions

  October 15, 2004 at 9:11 am

  #526914

  Are there no combinations of columns in the table that could constitute a unique key?

  Couldn't transactionid and trandate consitute a unqiue key?

  If you could describe in more detail what it is you want to do then it may be possible to avoid cursors entirely.

  LinkedIn Profile