Can a dynamic parameter be used in a table name?

talva

I have a need to set a parameter value in the name of the table. Is this possible?

For example, the database I am querying creates a new table each night resulting from an end-of-day process. The table gets named with a date stamp (i.e. tablename_YYYYMMDD). I would like to dynamically set the date on the table, so the query would look like,

select * from tablename_?.

Can this be done?

talva

NEVERMIND - I found a solution here: http://www.birt-exchange.org/org/forum/index.php/topic/23862-dynamic-table-name-in-data-set/page__s__c2e186ecebca3449fa862b8a452ad77c