Hi All,

Please help. I am using SQL 2000. Here is an example. I have a table called "Saving." This table has two columns, SSN and AMOUNT. At the midnight of each day, I want SQL 2000 to automatically add 10% to the AMOUNT column.

I am not sure where to star, or what method I should use. Do I write a stored procedure and then schedule a task/job? What do I do? Please help.

Thank you.

Leon

If you will like to always update the amount column everyday

Use
but I will also caution and make sure that this is what you really want to do every time, if not make sure you add a where clause. It might be you only what to update records that have changed.

let me know if you to only change only columns that have changed values.

Jaime E. Maccou

sorry i forgot something. to schedule it create a stored procedure and schedule it in a job


 If you will like to always update the amount column everyday

Use
create procedure usp_updateAmount
as
UPDATE saving
SET amount = amount * 1.1



but I will also caution and make sure that this is what you really want to do every time, if not make sure you add a where clause. It might be you only what to update records that have changed.

create procedure usp_updateAmount
as
UPDATE saving
SET amount = amount * 1.1
WHERE (SSN= '999999999')


let me know if you to only change only columns that have changed values.

Jaime E. Maccou


Jaime E. Maccou

Hi Jaime,

Thank you very much for your help! :-) I know a little bit about writing stored procedure. I just wasn't sure if writing a stored procedure, and then schedule it to run is the best AND only method to do what I wanted to do. In other words, is this normally the method programmers would use? I am pretty new to the web-database related world. I am still trying to explore what I can and can't do, and the best method to do it.

Thanks again.

Leon