After completing this chapter, you will be able to:
In the previous chapter, you learned how to increase the performance of your queries. Now you know how to create an efficient set of queries to give your users the most important information from your application using predefined queries in stored procedures or views.
However, in all but the simplest applications, there's no way to figure out ahead of time all the possible variations on what information your users will need or how they'll want it filtered and organized. Rather than try to plan for every possibility, you can give the users control over the information the application provides. This chapter will show you how to build queries dynamically based on choices that the user makes at runtime.