Let's say I have table with these values:
Flag=1 means add to order. When I am done processing these are rows I want to see
The camera is left off the order and the LNITMSEQ column now has a row number indicating the line counter on the order for the items that are to be included on the order. How do I structure update statement to accomplish this by updating the value for LNITMSEQ?