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

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

1019-B-C-A-C-P-A(2872).docx

120 KBs Word File

Students Have Also Explored These Related Cost Accounting Questions!