Need help to update database field periodically

[phrajib]

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

[dee-u]

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

[phrajib]

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

[mendhak]

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

Try looking up SQL Server jobs.