SP Help - Generate unique row ID's every time SP is executed

[R000k]

Hello,

I'm having some issues figuring out how to get this piece of code accomplished.

I need to manually create a 10 digit ID number that will continually increase every time the stored procedure is executed.

For instance:


This is my result set the first time I execute my SP:


ID Employee_Name
---- ---------------------
1111111111 Michael Jordan
1111111112 Larry Bird
1111111113 Magic Johnson
1111111114 John Stockton
1111111115 Charles Barkley
1111111116 David Robinson


This is the result set the next time the SP is executed:

ID Employee_Name
---- ---------------------
1111111117 Michael Jordan
1111111118 Larry Bird
1111111119 Magic Johnson
1111111120 John Stockton
1111111121 Charles Barkley
1111111122 David Robinson


I know I need to store the ID's somehow but I cannot figure out how to get this started. Any help would be greatly appreciated.

Thank you,

Mike

 

[denimined]

Make the id field a 10 digit identity field and then seed the identity to 1,000,000,000 (or whatever).


eg

create table TBL (ID decimal(10) not null identity, 
                  name varchar(30))
GO;
dbcc checkident (TBL, RESEED, 1000000000)