Explore BrainMass

Explore BrainMass

    Examples of case statements

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Give an example of a business problem solved using a case statement. Give an example for a business problem solved with an IF statement. Can IF statements replace SELECT statements, why or why not?

    © BrainMass Inc. brainmass.com April 1, 2020, 1:33 pm ad1c9bdddf

    Solution Preview

    1. Case Statement:

    Behavior: When a particular case is met, then it replace the formulea or value in the putput parameter

    Business Problem: Calculate the average VOC ratings for the vendor performance for inside SLA and outside SLA?
    For the above business problem, case statement is best suited, if the DB captures ...

    Solution Summary

    Examples of case statements are presented.