![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Wed, 08 Aug 2007 @ 09:42:20 GMT
Subj: | | Re: Create table in a Macro |
|
From: | | D silva, Joseph Vinish |
| When using a macro to create a table, is there any way of adding a date suffix to the table name? I know that you can't use a parameter in
the create table script, so I was wondering if there is any other way of doing it. Is this possible? | |
Try stored proc with dynamic SQL ...
regards
Joseph D'silva
| |