Update all records in one column with data from the first record in another table
I am looking to update all the rows of one column in a table with the value in a the first row in a seperate table.
I have tried
SET IGFMerchantName = AWHeader.AWMerchantName
FROM AWHeader CROSS JOIN
But this updates IGFMerchantName from InputGlobalFeed with various record from AWHeader and not just AWMerchantName.
Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.