mercwrought
Programmer
Ok here is one for you
How do you use a variable in an IDENTITY function?
Example
How do you use a variable in an IDENTITY function?
Example
Code:
declare @stuff int
set @stuff = (select min(somevalue) from sometable )
select idnumber as idnumber, amount as amount, IDENTITY(int,@stuff,1)
into thattable
from someothertable