title: union all on views based on table
body: <p>i have a database table with a list of sql views </p>
  
  <p>i want to create a new view or stored procedure that based on which views are in that table will return those views unioned
  like this </p>
  
  <pre><code>SELECT     ALINE1, HOME, EMAIL, EXPIRE, EDATE7, type
      FROM         dbo.campaign_membership_30
      UNION ALL
      SELECT     ALINE1, HOME, EMAIL, EXPIRE, EDATE7, type
      FROM         dbo.campaign_membership_30n
      UNION ALL
      SELECT     ALINE1, HOME, EMAIL, EXPIRE, EDATE7, type
      FROM         dbo.campaign_membership_60n
      UNION ALL
      SELECT     ALINE1, HOME, EMAIL, EXPIRE, EDATE7, type
      FROM         dbo.campaign_membership_today
      UNION ALL
      SELECT     ALINE1, BOOKNO, EMAIL, DEPART, DEP7, type
      FROM         dbo.depart_151days
      UNION ALL
      SELECT     ALINE1, BOOKNO, EMAIL, DEPART, DEP7, type
      FROM         dbo.depart_90Days
  </code></pre>