Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: store procedure check expirydate
03-22-2008, 12:24 PM #1
- Join Date
- May 2007
- Thanked 0 Times in 0 Posts
store procedure check expirydate
halo there, i need some help on writing store procedure.
i have 1 table which store the productid,productname,customerid expirydate of the product, remindersent.
customer table---> cusotmerid, customeremail
wat i wan to do is, i wan to check the expiry date for each customer 's products .
if the date diff between expirydate and today is 30days, then send a reminder to the customer and update the remindersent to 1. if the date diff expirydate and today is 14days, then send a reminder to the customer and update the remindersent to 2... how i write tis in store procedure?
plz guide me on how to write it. i know the basic for the store procedure, select, update, insert and delete only.thank you.hope can hear frm u all as soon.....coz urgent..plz help.
03-25-2008, 02:41 PM #2
- Join Date
- Jun 2002
- Zwolle, The Netherlands
- Thanked 31 Times in 31 Posts
what is the part where you have the problem?
- processing the table which holds the product?
- creating the code to send an email?
- do the calculations with the dates?
- all of the above?
I am the luckiest man in the world