A table contains three columns such as id (int), setupdate (datetime) and examnumber (varchar(20)).
id is an identity column
while inserting the setupdate,
examnumber will be automatically updated to the table.
whereas the examnumber which should have Month and Year of the setupdate like Oct 2010. and also One sequence number will be binded to that column like Oct 2010 01, Oct 2010 02, and so on.
Any one help to write a Single Stored Procedure to do this.
id is an identity column
while inserting the setupdate,
examnumber will be automatically updated to the table.
whereas the examnumber which should have Month and Year of the setupdate like Oct 2010. and also One sequence number will be binded to that column like Oct 2010 01, Oct 2010 02, and so on.
Any one help to write a Single Stored Procedure to do this.
Comment