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

Appendix D: Advanced SQL Query Techniques

Listing D-1

Listing D-2

Listing D-3

Listing D-4

Listing D-5

Listing D-6

Listing D-7

Listing D-8a

Listing D-8b

Listing D-8c

Listing D-8d

Listing D-8e

Listing D-9a

Listing D-9b

Listing D-9c

Listing D-10

Listing D-11

Listing D-12a

Listing D-12b

Listing D-12c

Listing D-12d

Listing D-12e

Listing D-13a

Listing D-13b

Listing D-14a

Listing D-14b

Listing D-15a

Listing D-15b

Listing D-16a

Listing D-16b

Listing D-16c