thegiraffe
Programmer
A little out of my league.....
I want to write a trigger / stored procedure to run on a pre defined day of the month (ie. the first), every month.
I want it to run only once a month checking information from a sales table and setting up records to a pending table if my criteria is matched.
Complete beginner with this so any pointers and tips / scripts will help me no end (and save my ass!!)
Cheers Dave
Theres nothing worse than an idea when its the only one we have!
I want to write a trigger / stored procedure to run on a pre defined day of the month (ie. the first), every month.
I want it to run only once a month checking information from a sales table and setting up records to a pending table if my criteria is matched.
Complete beginner with this so any pointers and tips / scripts will help me no end (and save my ass!!)
Cheers Dave
Theres nothing worse than an idea when its the only one we have!