Posted by Alexander Kuznetsov on 10/01/18 11:34

instead of

sum(qtr_payroll)/((sum(emp1+emp2+emp3))/12) as avwage

use 2 columns

sum(qtr_payroll)
sum(emp1+emp2+emp3)

also include

count_big(*)

in the view definition

• Next in forum: Access to SQL Server
• Prev in forum: Indexing a View
• Thread view: Re: Indexing a View

[Reply to this message]