Consecutive Row Numbers?

Another option that I use is Rank to do this.

Rank(RowID,thisTable.RowID,true )

15 Likes