Good after noon, i am most likely certain that this is an easy task but for some reason am just not able to grasp it.
In a stared proceedure i have the following:
declare @tblTemp table(consumerid int Identity(1,1), consumername varchar(50), consumeracct varchar(5), tags varchar(10))
Insert into @tblTemp (comsumername, consumeracct, tags)
select consumername, consumeracct, tags from dp_data
select * from @tblTemp
this is just the begining to what i am trying to accomplish but where i am having trouble is I want to be able to assign a variable to the Identity for the starting position. But no matter what i try @ $ % it will not let me assign a variable to the identity.
So then i found something about using @@identity and it was said that you could see what the last number used was, thought maybe if you made it = to some value it would do the same but alas it does not.
So can someone assist me and tell me how i can make the starting point of the Identity a variable?
THanks and have a great day.