I am creating an asp.net web application that will help managers and tutors track the schedule of a certain students current asessments. What I need the database to do is flag up when a student is behind on a particular module and then email their tutor this information perhaps a week before the due date?
Am I correct in thinking that I would use a stored procedure to extract this information?
If so could anyone point me in the direction of some sample code or resources that will get me on the right track?
Thanks in advance...