title: Need to Create a SQL View from List of Tables
body: <p>Trying to create a view where all the tables have the same fields but different data in them.  We have a table that we track each of these tables, and track which ones are active.  So I want a view that will tie all the active tables together in one view.</p>
  
  <p>Say you have tables A, B, and C.  Only B and C are active, table 1 lists each table and which is active.  So form table 1 we can get the table names we need for the view.</p>
  
  <p>It escapes me on how to do this on the SQL Server (2008 version)</p>