I want to create a table under sqlserver 2005 with a primary key field as: auto increment concatenated with with the current year.
example:
For year 2007, the primary key field must be like:
02007
12007
22007
.
.
.
3652007
For year 2008, the primary key field must be like:
02008
12008
32008
.
.
.
3652008
etc
Can you help to do it.
Thanks.
HI!,
Sorry for the blank post, my suggestion is to do it from front end. Since you can't use auto number, If you are using stored procedure for inserting then you can keep the logic inside it also.
Hope this will help
