I have a table within SQL that I need to update. There is only one column I want to update "USER_4" however I only want it to be updated based on a list of line items from column "CUST_ORDER_ID"
Currently I have from table "SYSADM_CUSTOMER_ORDER":
I want to update it to add values or change exsisting values in the USER_4 colum.
I have an excel file that lists the appropriate USER_4 Value based on the CUST_ORDER_ID that has already been defined an updated. However I need this data to be in my SQL table. There are about 3000 lines to be updated.
Is there a way to do this via a command or formula?