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
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
Step by Step Solution
3.36 Rating (177 Votes )
There are 3 Steps involved in it
Set up test data IF OBJECTIDdbo Vendors IS NOT NULL DROP TABLE dbo Vendors IF OBJECTIDdbo Invoices IS NOT NULL DROP TABLE dbo Invoices CREATE TABLE db... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
1019-B-C-A-C-P-A(2872).docx
120 KBs Word File
