I would develop a stored procedure to return the count of items too close to the warranty expire date. In the query, I would use the DATEDIFF function to find out if there are any matching rows. Then, I would create a scheduled job and have an email sent to me if the count is greater than zero.
Dig Deeper on SQL-Transact SQL (T-SQL)
Related Q&A from Roman Rehak
There are a few things you can do to tune SQL Server for improved reporting performance. Here are some generic and Reporting Services-specific ... Continue Reading
Learn SQL Server commands to manipulate column names in a table and turn column names into variables or rename SQL columns. Continue Reading
Discover the best solutions for encrypting, decrypting and restoring a database in SQL Server 2005. Continue Reading