Good Day

I have a table that stores a couple of tablenames in the same db.
The tablenames in the table can change from time to time.
Is it possible to loop through the tablenames in the table and run a query
against each tablename. I cannot hard code the table names in the query
because they can change from time to time.
Not sure how to accomplish this.

Thank You

Google "dynamic SQL".

Basically, instead of writing queries against fixed table names, you will write a stored procedure that will use T-SQL to write the queries into text strings, and you will then execute the query text strings. By having the stored procedure write the queries, they can be dynamically created at execution time.