Posted by Alexander Kuznetsov on 11/16/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?

[Back to original message]