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.