declare @strsqlcreatetable as nvarchar(255)

declare @tablename as nvarchar(255)

declare @strsql as nvarchar(255)

select @tablename = 'lclifecycle' + convert(nvarchar(2), datepart(mm, getdate())) + convert(nvarchar(4), datepart(yyyy, getdate()))

print @tablename

select @strsqlcreatetable = 'create table ' + @tablename + '(emp int)'

print @strsqlcreatetable

exec (@strsqlcreatetable) --there is your missing parenthesis!

😎 :hehe: