>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)')