Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Row ID, autonumber

Status
Not open for further replies.

cholotron

Technical User
Mar 20, 2017
4
CA
Good Morning All,

Is there a way to number rows?

Columns
so_num, so_line
6868,1
6868,2
6868,4
6868,5

to

so_num, so_line, my_rownumber
6868,1,1
6868,2,2
6868,4,3
6868,5,4

thank you all
 
Hi, thanks for you replay

Users complain that when they delete a "row" on our sales orders, our ERP does not "re-number" the SO Lines, according to them
it looks like something is missing, they want to avoid manually changing it. [smile]

I just wanted to know if with a SQL Script I could fix it.

thnks

john
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top