|
|
Posted by rong.guo on 10/21/05 20:24
Greetings!
I am now doing one type of analysis every month, and wanted to creat
table names in a more efficient way.
Here is what happens now, everytime I do the analysis, I will create a
table called something like customer_20050930, and then update the
table by using several update steps. Then next month I will create a
table called customer_20051031. Does anyone know if there is a better
way to do it? like using a macro variable for the month-end date? Now
everytime I have to change the table name in every single update step,
which would cause errors if I forget to change one of them. By using a
macro, I would only need to change it once.
Thanks!
Navigation:
[Reply to this message]
|