title: SQL Server wildcard in table name like in BigQuery
body: <p>In Google's BigQuery, it is possible to create tables with a sufix like:</p>
  
  <pre><code>my_dataset.my_table_20170601
  my_dataset.my_table_20170602
  my_dataset.my_table_20170603
  my_dataset.my_table_20170604
  ...
  </code></pre>
  
  <p>This pattern can be undertood as: <code>my_dataset.my_table_YYYYMMDD</code>. </p>
  
  <p>Then, it is possible to group them in a select like:</p>
  
  <p><code>
      SELECT * FROM TABLE_QUERY(my_dataset, 'REGEXP_MATCH(table_id, r"my_table_\d*")')
  </code></p>
  
  <p>It works like an union throughout the tables which names match the pattern.</p>
  
  <p>I am looking for something similar in SQL Server. Is that possible by any chance?</p>