title: Pass SSRS parameter to SQL query
body: <p>I've built an SSRS report that is supposed to look at data from one of several tables with similar names - i.e., table001, table010, table011, etc. When I was building the report, I was only including three of the tables, out of more than a dozen. Everything worked fine until I added all the rest of the tables to the query, using multiple SELECT statements UNIONed together; it was trying to sort through so much data that it was taking almost half an hour to render the report. That's not going to work.</p>
  
  <p>Is there a way to pass an SSRS parameter to the SQL query, specifying which table to access?</p>