DECLARE @tableGUID uniqueidentifier; SET @tableGUID = NEWID() DECLARE @DynamicSQL nvarchar(1000); SET @DynamicSQL = N'SELECT * INTO ' + @tableGUID + ' FROM OtherTable'; EXEC(@DynamicSQL);