I have a situation where we will actually want to create separate tables for a number of country dial codes. Each table will be extacly the same. SO we wish to start with a template and create the tables, throught a stored procedure, whiwh will assign a table name based upon the contents of another table. Thus, a table name will be row1col1+row1col2 which would then be used as the table name with an assigned prefix. SO @tablename = @prefix + row1col1+row1col2.
Next we will CREATE TABLE @TableName.......
and so on....
The only problem IS when I use @TableName that is exaactly what I get, and not the contents of the vaiable.
I KNOW this is not a great idea, but it is something Sales wants and we have had a BIG problem using one large table ( WHICH we already have ).
Any suggestions ?
Thanks...
Edited by - spartanx15 on 01/04/2003 2:39:46 PM