Do you have disparate data sources that you need to merge together for reporting purposes? Do you want to protect your database by eliminating SQL queries directly in code? Do you have the need to run dynamic queries for your reporting processes? Do you want to house keep your report data sources in a common, well organized location for easier maintenance? If you answered yes to any of these then a stored procedure (SP) is the right fit for you. I have 10 years of experience creating SP's to cover all these scenarios and more!