I am having a table in my database called "Schedules" ,this table stores the schedules for guards,for example : " a specific guard works in a specific site at specific interval of time" , my question is : how to create a field to be a like a distinctive
consecutive number for each guard indicating the schedule sequence,hope you got my question right.
moe_caruso
Member
9 Points
43 Posts
How to make a consecutive number for each unique entity in a table?
Jun 24, 2012 07:29 AM|LINK
Hello guys ,
I am having a table in my database called "Schedules" ,this table stores the schedules for guards,for example : " a specific guard works in a specific site at specific interval of time" , my question is : how to create a field to be a like a distinctive consecutive number for each guard indicating the schedule sequence,hope you got my question right.
Thanks.
Mudasir.Khan
All-Star
15346 Points
3142 Posts
Re: How to make a consecutive number for each unique entity in a table?
Jun 24, 2012 06:19 PM|LINK
please check this
http://blogs.msdn.com/b/sqlcat/archive/2006/04/10/sql-server-sequence-number.aspx
http://www.sqlteam.com/article/custom-auto-generated-sequences-with-sql-server
moe_caruso
Member
9 Points
43 Posts
Re: How to make a consecutive number for each unique entity in a table?
Jun 26, 2012 05:29 AM|LINK
Can you check the link please,it's not working.
Thanks.