1. Create a stored procedure called spFindInvoices that accepts two parameters- @NameVendor of type varchar and @BalanceLimit of type smallmoney. In this procedure, write a query that shows the following table when @NameVendor is Federal Express Corporation and @BalanceLimit is 0:

VendorName InvoiceNumber InvoiceDueDate Balance**

Federal Express Corporation 963253264 2012-04-17 00:00:00 52.25

Federal Express Corporation 263253268 2012-04-20 00:00:00 59.97

Federal Express Corporation 263253270 2012-04-21 00:00:00 67.92

Federal Express Corporation 263253273 2012-04-21 00:00:00 30.75

**Balance = InvoiceTotal-CreditTotal-PaymentTotal

Code two EXEC statements that call/test the spFindInvoices procedure with the following arguments:

a. @NameVendor = Federal Express Corporation and @BalanceLimit i= 0 (pass by name)

b. @NameVendor is Blue Cross and @BalanceLimit is 100 (pass by position)