1. Create a stored procedure called spFindinvoices that accepts two parameters- @NameVendor of type varchar(100) and @BalanceLimit of type smallmoney. This procedure displays the VendorName, InvoiceNumber, InvoiceDueDate and Balance of VendorName with the name equal to @NameVendor and where the balance is greater than @BalanceLimit. If you call/test the procedure with @NameVendor = 'Federal Express Corporation' and @BalanceLimit = 0, the following table will be displayed. Vendor Name 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 = Invoice Total-CreditTotal-PaymentTotal Code two EXEC statements that call/test the spFindinvoices procedure with the following arguments: a. @NameVendor is 'Federal Express Corporation' and @BalanceLimit is 0 (pass by name) b. @NameVendor is Blue Cross' and @BalanceLimit is 100 (pass by position) 1. Create a stored procedure called spFindinvoices that accepts two parameters- @NameVendor of type varchar(100) and @BalanceLimit of type smallmoney. This procedure displays the VendorName, InvoiceNumber, InvoiceDueDate and Balance of VendorName with the name equal to @NameVendor and where the balance is greater than @BalanceLimit. If you call/test the procedure with @NameVendor = 'Federal Express Corporation' and @BalanceLimit = 0, the following table will be displayed. Vendor Name 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 = Invoice Total-CreditTotal-PaymentTotal Code two EXEC statements that call/test the spFindinvoices procedure with the following arguments: a. @NameVendor is 'Federal Express Corporation' and @BalanceLimit is 0 (pass by name) b. @NameVendor is Blue Cross' and @BalanceLimit is 100 (pass by position)