Code three calls to the procedure created in exercise 1:
a. passed by position with @Vendor Var = 'Z'% and no balance range
b. passed by with @Vendor Var omitted and a balance range from $200 to $1000
c. passed by position with a balance due that's less than $200 filtering for vendors whose names begin with C or F.
EXERCISE 1 FOR REFERENCE
1. Create a stored procedure named sp Balance Range that accepts three optional parameters. The procedure returns a result set consisting of Vendor Name, Invoice Number, and Balance for each invoice with a balance due, sorted with largest balance due first. The parameter @Vendor Var is a mask that's used with a LIKE operator to filter by that vendor name, as shown in figure 14-5. @Balance Min and @Balance Max are parameters used to specify the requested range of balances due. If called with no parameters or with a maximum value of 0, the procedure should return all invoices with a balance due.