List of Listings

Appendix C: Views, Stored Procedures, and Triggers

Listing C-1 The “Alphabetical list of products” view
Listing C-2 Order Header Query view
Listing C-3 ABC Sales by Customer query
Listing C-4 Top 10 Customers and Bottom 10 Customers view
Listing C-5 The new ABC Sales by Customer query
Listing C-6 sp_SubTotal
Listing C-7 Check Product Order Details trigger