Follow the evolution of an SQL query and automate your database reporting

Overview: This download shows you how a relatively simple SQL query can evolve into a complex SQL Server stored procedure that automatically sends the correct data to the correct person responsible for acting on that information.

Creating an automated SQL query that will retrieve timely data and transmit that information to a person who can act upon it is a basic task for many SQL Server database administrators. However, the process for developing that automated query is not always as obvious as you might expect. This download takes you through a typical evolutionary development process that goes from the basic query to the creation of a stored procedure to the implementation of an e-mail distribution system. Following the procedure outlined in this download will give you a solid foundation for your next automated query project.Can you improve this download? Do you have a better approach or possibly a way to improve the overall performance of the query? Make a suggestion in the associated discussion forum and we may just incorporate your idea into the next version of this download.

(Is this item miscategorized? Does it need more tags? Let us know.)

Format: PDF | Size: 102KB | Date: Jul 2005 | Version: 1.0 | System Requirements: Adobe Reader 5.0 or later | License: copyright | Downloads: 8994