quote:

---

Originally posted by blocker

Good day.!

I have read about trigger events in sql server. I just want to know if is it possible to create a trigger that will execute a vb script or sql server query when the data like date of the column field is less than 5 days of the current system date.?

Thank you for giving time & God bless..

---

quote:

---

Originally posted by blocker

I need this trigger to execute everytime one of the date on a table in column(entrydate)is less than 5 days of the current system date..Everytime it occurs, the trigger will execute..I still cant figure this out.

---

CREATE TRIGGER YourTrigger
ON Table
AFTER UPDATE
AS 
BEGIN
... -- your code here
FROM INSERTED
WHERE Date < DATEADD(dd,DATEDIFF(dd,0,GETDATE())-5,0)
END

quote:

---

Originally posted by blocker

thank you.

Will this trigger only works when i insert data.? I have more than 500 data on the table, assuming that today's system date is January 12, 2010, when one of the data thats holds date value in sql server table is less than 5 days of the current system date, the trigger will execute even if i dont do any update, insert, or delete in the table. Will this possible?

I'm trying to figure out to put some fields for date in the table to hold the current system date, when it is inserted, the trigger will execute to loop or search all the fields of the table and notify if it founds date value less than the date inserted which is the current system date.This is just an idea to do this.hehe.But if this works, what will be the trigger event to loop or search when the current system date is inserted.?

Thank you guys very much for giving time.

God bless us.

---

quote:

---

Originally posted by blocker

how could i do that.?? Im really confused.heheh.pls help me guys..

Ill try all your help right here to the best of mine..

Ok. my solution above to insert a field for current system date,run the trigger, and execute the stored procedure to find the date less than 5 of the current system date is right, but instead of using loop, i will use set based solution.? How could that be.? I still dont have knowledge about set based solution.

Thank you for giving time.

God bless.

---

quote:

---

Originally posted by blocker

ok.we're getting close to the solution..After I insert the current system date, i will execute the trigger which will find over 500 data of which date is less than 5 days of the current system date. Pretty close this should look like this.

CREATE TRIGGER datefinder
ON tblcostumerorder
AFTER UPDATE
AS
BEGIN

SELECT * FROM tblcostumerorder
WHERE dateordered <DATEADD(dd,DATEDIFF(dd,0,GETDATE())-5,0)>
END

If I've made something wrong on this trigger please change it to a more accurate way.

If this is correct, I just want to know on how to get all the data that was returned by the sql query on this trigger event and insert it to a temporary table like tbl_temp_datefinder.

Thank you guys for giving time. God bless.

---

quote:

---

Originally posted by blocker

after i inserted it to a temporary table, i will execute a vbscript to send sms to the corresponding customer base on that temp table..Did i made correct on my trigger.?

Thank you guys for giving time.

God bless

---

quote:

---

Originally posted by blocker

Ok.so i decided not to put the data in a temp table. I just want to know the syntax on how to return the data resulted from query on the trigger event.Example if it founds 10 data upon triggering. Just want also to ask if teleflip.com is free of charge or i need to register first.

Thank you very much guys for a very brilliant ideas. We're almost done.

Thanks God.

Thank you for giving time.

God bless

---