I have a large number of tables that all contain similar columns but are contextually different. I need to send select columns from all of the tables. There is a template of columns I need to follow and any column I do not have a value for in a particular table I need to send null to keep the format intact. Basically a flat file.
My approach has been to make separate queries from each table and use union all to basically "slap them together" but I wondered if there was a better approach. I do not really have time for an SSIS approach because of time but information on this may be helpful if a periodic feed is needed later.
Thanks for any help