I had this come up when I was trying to insert the row number for the purpose of populating a SeqNo. This is what it looks like…
ROW_NUMBER() OVER (ORDER BY [Column Name]) as SeqNo
I had this come up when I was trying to insert the row number for the purpose of populating a SeqNo. This is what it looks like…
ROW_NUMBER() OVER (ORDER BY [Column Name]) as SeqNo