Need help to update database field periodically

Dear Friends,

I have a problem in my hand...

I am describing a scenario as my problem here...

Lets think I have an field in my database(MS SQL Server) as joining date and also another field that contains service length( in no. of hours).

I want to update this service length every hour automatically in my database.

How I can do that ?

Pls Help me with necessary codes if possible.

--Rajib

What if you would just calculate the timespan when you need it?

Thanks for ur quick response.

But my system add some values to the peoples on their service length in every hours. I can run a process every hour manually from front-end. By I want to reduce my work. So i am wishing to update those values autoimatically from my database.

if u asked me why i am using service length field in database, i will say no need. but i need to calculate the service length at least when the database will update value automatically.

can anyone help me?

if trigger and procedure is needed pls write details. I am not so strong in this things. Pls give some references for further study on those if necessary.

I am waiting for ur response.

Best Regards,

Rajib

Please avoid crossposting. I just replied to this in another thread you posted elsewhere.

Try looking up SQL Server jobs.