Microsoft SQL Server : Move through rows in query

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by KevCB226 0n 08 January 2009

I need some help on a stored procedure I’m creating.

Here are the facts:

At work we have a web based CRM and amongst various details stored in the database (SQL Server 2000), it also stores actions created by users.

What I’m trying to do is setup a stored procedure that checks these actions.
If they are not completed and overdue or not completed and are near the due date, I want to send an e-mail to the user to remind them or bring to their attention that it is overdue.

Learn more about Microsoft SQL Server databases here. Should you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting