Link to home
Start Free TrialLog in
Avatar of rhservan
rhservanFlag for United States of America

asked on

Defining a Data Entity

1. Please define what a data entity is. Is there more than one definition depending on use?
2. what would the data entity in a stored procedure, here are some example:
        a. SUM(CASE WHEN fifo.fuel_grade = 1 THEN fifo.fifo_cost END) AS gas_cost
        b. SUM(deliver.fuel_cost * deliver.gallons_remaining) / MAX  deliver.current_inventory)       AS fifo_cost
ASKER CERTIFIED SOLUTION
Avatar of TempDBA
TempDBA
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rhservan

ASKER

So, how would you define the data entity from the formulas in the question?