On 6/19/07, Ranieri Mazili <[EMAIL PROTECTED]> wrote:
> sure!.
>
> SELECTcast(((sum(A.qty_employees_total)
>-(sum(A.qty_absence)
>-sum(A.qty_vacation)
>-sum(A.qty_diseased)
>-sum(A.qty_indirect)
>-sum(A.qty_transferred))
>
Original Message
Subject: Re:[GENERAL] Subquery problems
From: Merlin Moncure <[EMAIL PROTECTED]>
To: Ranieri Mazili <[EMAIL PROTECTED]>
Date: 19/6/2007 10:40
On 6/19/07, Ranieri Mazili <[EMAIL PROTECTED]> wrote:
Hello,
I'm having another "prob
On 6/19/07, Ranieri Mazili <[EMAIL PROTECTED]> wrote:
Hello,
I'm having another "problem", I have a function that declares 12 variable,
one per month and each them execute a select like bellow:
DIV_MES01 := (select count(distinct production_date) from production where
extract(month from prod
