question archive Develop a stored procedure that will take a state abbreviation as parameter and list the names of the vendors in that state and the total amount still owed on invoices from each vendor
Develop a stored procedure that will take a state abbreviation as parameter and list the names of the vendors in that state and the total amount still owed on invoices from each vendor
Subject:Computer SciencePrice: Bought3
Develop a stored procedure that will take a state abbreviation as parameter and list the names of the vendors in that state and the total amount still owed on invoices from each vendor. (List only vendors to whom a positive amount is still owed; omit vendors to whom no amount is owed). The Canvas assignment includes a link to a script for a partially completed stored procedure called owed to state vendors. Review the code, including the comments, to understand the requirements of the stored procedure. You will complete the stored procedure, using the comments as a guide. HINT: test your stored procedure using a statement such as: CALL owed to state vendors ( 'CA' ) ;
