Not sure how to explain this but will try. So I have some purchase order with 1 or more lines. Not sure how to go about to write this query so that it take the last line with a "PART_ID" and put it into the first line.
In this example, line 2 has the Part_ID. I want to populate the part id into line 1 and remove line 2.
If there are 3 lines, the 3rd line will have the part ID value. It will populate the first line and remove line 2 and 3.
With this example, can this be done via SQL Query?