>Hi,
>
>I would like to dynamically create a table in a stored procedure based on a value that I have stored in a variable..
>
Here's a sample code that creates table in the current DB.
declare @TableName varchar(32)
SET @TableName = 'TestTable'
EXECUTE('CREATE TABLE ' + @TableName +
' (field1 char(3), field2 int)')
--sb--