Create a stored procedure named sp Balance Range that accepts three optional parameters. The procedure should return

Question:

Create a stored procedure named sp Balance Range that accepts three optional parameters. The procedure should return 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 15-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
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: