How to update many records with different values from another table

Question

question

m.rezaei asked Oct 28, '19

How to update many records with different values from another table

Actually I have two tables as following:

t1(orderid,batchnumber,gtin,expdate,password);

t2(orderid,batchnumber,gtin,expdate);

t1 has 1000 records with only password and other fields has null values

t2 has 1000 diferent records

Now I,m looking for a way to update t1 null values with t2 values

sql-server joins script update_query

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2019-10-28T12:46:16Z

m.rezaei answered Oct 28, '19

My problem has solved by following script:

with cts as(
select row_number() over (order by id) as row#, ordercode,batchnumber from tempBarcodes 
)
update barcodes set orderid=c.ordercode,batchNumber=c.batchNumber from cts c
inner join barcodes b 
on c.row#=b.id

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question