Question
Write a mysql script that creates and calls a stored procedure named test. THis procedure should create a cursor for a result set consists of
Write a mysql script that creates and calls a stored procedure named test. THis procedure should create a cursor for a result set consists of the vendor_name, invoice_number, and balance_due which is (invoice_total - payment_due - credits_due) with a balance due greater than or equal to 5,000,
The results should be sorted in decending sequence by balance due.
The invoice data should be placed in 3 groups based on the balance due, 20,000, or more, 10,000 - 20,000 or 5-10,000.
When your done the string variable thats returned should be in this format:
20,000 more more: 10,000 to 20,000: 11130.70|P-0680|Malloy Lithographing INC// 5,000 to 10,000: 6586.62|O-2436|Malloy Lithographing INC//
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started