How to set constraint on table row

[june]

Hi,
I have a table like given below:

SectionName SectionCode IRN

Production PROD 2001
Electrical EL 4001
Mill House M 5501
EOT Crane M 5501
Plant M 5501
Motor Garage M 8001

First Issue The IRN's of all the departments will be incremented one by one and reset to their original value at the start of new financial year. Can I set this using constraints? I know constraints are set on columns. I don't know whether its possible row-wise.

Second Issue The sections Mill House, EOT Crane and Plant have same IRN range. For indent of any one of these sections, how I can I update the other two sections to the same value.

Thanks for any help.

[Hack]

First Issue: Constraints are used for validation. I have the need to start fresh for a number of things at the beginning of each year. I have "roll over" stored procedures that I run, once a year, to accomplish this for me.

Second Issue: I'm unclear what you are asking for.

http://forums.devx.com/showthread.php?t=170699

[june]

I have "roll over" stored procedures that I run, once a year, to accomplish this for me.

I think I should create a stored procedure that will run automatically once a day(when the server starts). If the day happens to be 1st April, then IRN's of all the departments will be reset to their starting value. Can you please show me how to do it?

I have solved the second issue. Again thanks.

[Hack]

What is your resolution for the second issue?

It might help someone else with the same or similiar problem.

[june]

I have solved both the issues. For first issue I have created a job that will update the IRN's if it happens to be 1st April. The second issue is specific to the application I am developing.

[Hack]

Thanks.