|
midrange.com
If you insist on SQL, basic Boolean logic still helps:
> From: darren@xxxxxxxxx
>
> C* multiply by duty rate percentage
> C+ ifnull(case
> C+ when :FEDATE>=F4COOD
> C+ then 0
> C+ when :FEDATE<F4COOD
> C+ and FLPROF='Y'
> C+ then FLPROR
> C+ when :FEDATE<F4COOD
> C+ and FLPROF<>'Y'
> C+ then FLNORR
> C+ end,0)
Can be replaced by this:
C* multiply by duty rate percentage
C+ ifnull(case
C+ when :FEDATE>=F4COOD
C+ then 0
C+ when FLPROF='Y'
C+ then FLPROR
C+ else FLNORR
C+ end, 0)
I'm not sure of the effect on performance; it would depend on how smart
the SQL engine is.
Joe
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
