-- Brings PO 0000000012 (invoice 907260825592619) in line with the POS-created headers -- (PO 1-8): the columns the POS fills that our insert left NULL. USE posinv; GO DECLARE @receiver int = 1; -- your emp_no from posbdat..Employees UPDATE dbo.InvoiceHeader SET Salesman = '', Receiver = @receiver, Deliverer = '', ReceivedInvoice = 1 WHERE PONumber = '0000000012'; SELECT PONumber, Salesman, Receiver, Deliverer, ReceivedInvoice FROM dbo.InvoiceHeader WHERE PONumber = '0000000012'; GO