how to create variable table name

Database
N/A

how to create variable table name

Hi there,

            I have a query that requires reading data from one table on weekly basis, however, when it is end of month, all queries should be extracted from another table. so far, i am manually change table names at the end of month and beginning of 1st week of the month to switch b/w two source tables, and it needs to repeat more than 10 times.. is there any easy way to be replace by a variable, so i only need to assign once, rather than 10 times?

Eg... 

CREATE    VOLATILE TABLE Rpt_Dt AS

(

SELECT

CAST('24/04/2016'  AS DATE FORMAT 'dd/mm/yyyy') AS Rpt_End_Dt     -- Reporting period end date can be EOW / EOM / EOY

,CAST('30/04/2016' AS DATE FORMAT 'dd/mm/yyyy')AS Mth_End_Dt     -- EOM / EOY

, ECertV.ACDM_AC_Hrtbt_Wkly AS TblNm           --- turn on WK-End           

-- ECertV.ACDM_AC_Hrtbt_Mthly AS TblNm         --- turn on Mth-End       

) WITH DATA

ON COMMIT    PRESERVE ROWS;

SEL * FROM TblNm

WHERE FinalisedDt LE (SEL Rpt_End_Dt FROM PSBIT.SBIT_Hrtbt_Rpt_Dt)

..

...

...

...

SEL * FROM TblNm

...

...

...