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.