title: Select all values from all tables with specific table name
body: <p>EDIT original question:</p>
  
  <p>Our UDW is broken out into attribute and attribute list tables. </p>
  
  <p>I would like to write a data dictionary query that dynamically pulls in all column values from all tables that are like <code>%attr_list%</code> without having to write a series of unions and update or add every time a new attribute list is created in our UDW.</p>
  
  <p>All of our existing attribute list tables follow the same format (number of columns, most column names, etc).  Below is the first two unions in our existing view which I want to avoid updating each time a new attribute list table is added to our UDW.</p>
  
  <pre><code>CREATE VIEW [dbo].[V_BI_DATA_DICTIONARY]
  (      ATTR_TABLE
    ,ATTR_LIST_ID
    ,ATTR_NAME
    ,ATTR_FORMAT
    ,SHORT_DESCR
    ,LONG_DESCR
    ,SOURCE_DATABASE
    ,SOURCE_TABLE
    ,SOURCE_COLUMN
    ,INSERT_DATETIME
    ,INSERT_OPRID
     )
  AS
  
  SELECT 'PREAUTH_ATTR_LIST'             ATTR_TABLE
    ,[PREAUTH_ATTR_LIST_ID]          ATTR_LIST_ID
    ,[ATTR_NAME]                     ATTR_NAME
    ,[ATTR_FORMAT]                   ATTR_FORMAT
    ,[SHORT_DESCR]                   SHORT_DESCR
    ,[LONG_DESCR]                    LONG_DESCR
    ,[SOURCE_DATABASE]               SOURCE_DATABASE
    ,[SOURCE_TABLE]                  SOURCE_TABLE
    ,[SOURCE_COLUMN]                 SOURCE_COLUMN
    ,[INSERT_DATETIME]               INSERT_DATETIME
    ,[INSERT_OPRID]                  INSERT_OPRID
  FROM [My_Server].[MY_DB].[dbo].[PREAUTH_ATTR_LIST]
  
  UNION
  SELECT 'SAVINGS_ACCOUNT_ATTR_LIST'     
    ,[SAVINGS_ACCOUNT_ATTR_LIST_ID]  
    ,[ATTR_NAME]                     
    ,[ATTR_FORMAT]                   
    ,[SHORT_DESCR]                   
    ,[LONG_DESCR]                    
    ,[SOURCE_DATABASE]
    ,[SOURCE_TABLE]
    ,[SOURCE_COLUMN]
    ,[INSERT_DATETIME]               
    ,[INSERT_OPRID]                  
  FROM [My_Server].[MY_DB].[dbo].[SAVINGS_ACCOUNT_ATTR_LIST]'
  </code></pre>