Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Can a dynamic parameter be used in a table name?
Migrateduser
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?
Find more posts tagged with
Comments
There are no comments yet