|
Posted by Alexander Kuznetsov on 09/29/43 11:34
Bethany,
I would try this indexed view definition:
sum(qtr_payroll) sq1,
sum(emp1) se1, sum(emp2) se2, sum(emp3) se3,
count_big(*) cb
and calculate the average when you select from the view.
BTW, what are the types of emp1, emp2, emp3?
You might get an 'imprecise expression in where clause' error if they
are float.
what do you need the condition for:
(emp1 <> 0 or emp2 <> 0 or emp3 <> 0
Why are you using the expression sum(disc * 0) as disc?
Navigation:
[Reply to this message]
|