The queries are updating lookup tables that do not have a value by using a subquery to the lookup table.

I like that idea of using a computed column as these will be scanning through lots of data.

WHERE [column1] + [column2] NOT IN

(SELECT [column3] + [column4] from dbo.table order by [column1] + [column2])