Ketema <[EMAIL PROTECTED]> writes:
> Man so simple! is your solution the same as:
>
> num_provisioned < num_products AND (num_open_issues + num_provisioned
> + num_canceled) < num_prods
>
> which is what i finally came up with
This can be simplified to "num_open_issues + num_provisioned +
nu
Ketema wrote:
i have a record set like below:
num_prods|num_open_issues|num_provisioned|num_canceled
1|0|1|0
2|0|0|2
3|0|1|1 *
2|0|1|1
1|0|0|1
2|0|0|0 *
3|3|0|0
3|0|0|3
3|1|0|2
3|2|0|1
2|0|2|0
Of the list above only row 3 and row 6 should be returned.
Plain english definition:
With a result
Man so simple! is your solution the same as:
num_provisioned < num_products AND (num_open_issues + num_provisioned
+ num_canceled) < num_prods
which is what i finally came up with
---(end of broadcast)---
TIP 5: don't forget to increase your
where num_prods > num_open_issues + num_provisioned + num_canceled
if those columns are nullable (which they don't seem to be) you'd have
to convert the NULLs (i.e. coalesce(num_canceled,0) )
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Ketema
