Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

MongoDB Applied Design Patterns Practical Use Cases With The Leading NoSQL Database

Authors: Rick Copeland

1st Edition

1449340040, 978-1449340049

More Books

Students also viewed these Databases questions

Question

What do Dimensions represent in OLAP Cubes?

Answered: 1 week ago