Using AP Database

Unit $4$ Lab Exercise $2$

Test the function you wrote for exercise $1$ using the following select:

SELECT VendorName, InvoiceNumber, InvoiceID, InvoiceDueDate, InvoiceTotal $-$ CreditTotal $-$

PaymentTotal AS Balance FROM Vendors JOIN Invoices ON Vendors.VendorID $=$

Invoices.VendorID WHERE InvoicelD $=$ dbo.fnPaidInvoicelDXX$()$;

Hint: When getting ready to use the select provided to test your function remember to adjust

the fnPaidInvoicelDXX name to what you named the function you created.

$---$ Paste below this line the run results from executing the select you

used to test your function$--$

Paste here