I am needing to compare the data from 2 different locations.

I have a openrowset to a remote location i bring back the null values when i do a left join from homeoffice to remote sites. and these i have to then compare all columns case hqx = remotex then 't' else 'f' for all tables. since i have over 97 tables i can not manually create each comparison. i have any where from 9-45 columns i need to match up. i have all the others stuff working but i needed a way to dynamically create these temp tables.