Help using @variable while creating a new table

[bmacbmac]

Hi,

I would like to create a new table with an identity. I'm hoping to run this script unattended.

I would like the beginning counter to be the max(id) + 1 from a different table.

So far I have tried

declare @maxirangeid int
set @maxirangeid = (select MAX(irangeid) + 1 from tempblockbase)

create table tempnewblock (irangeid int identity(@maxirangeid, 1), ilandid int, minint int)

But getting a syntax error.

Is there a way for me to do this?

Thanks!

 

[TysonLPrice]

Maybe try:

declare @maxirangeid int
DECLARE @DynamicSQL nvarchar(1000);
set @maxirangeid = 5
SET @DynamicSQL = 'create table tempnewblock (irangeid int identity(' + convert(varchar,@maxirangeid)
 +  ', 1), ilandid int, minint int)'
print @dynamicsql

EXEC sp_executesql @DynamicSQL;

 

[bmacbmac]

Worked perfectly thanks!