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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.