I was thinking I could look at sys.objects and sys.columns to get a list of tables and names and then use a cursor to loop through it all.

Stupid question, but it's late in the day so bear with me....In a UNION statement, do both tables have to have the EXACT SAME number of columns and data types, or is it only that IF the columns ...