Question: Conditional Logic and Loops
Explore how to write a stored routine that uses loops and conditional logic to evaluate suppliers' performance metrics. Learn to handle variables and control flow within routines to classify and insert results without modifying base tables.
We'll cover the following...
We'll cover the following...
Question
Given the following structure of the Suppliers table:
Field | Type |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Where, SupplierID is the primary key. The table contains information about suppliers of products.
The operations team needs a weekly supplier health snapshot for ...