Re: DECODE

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Sat, 17 Apr 2010 09:51:53 +0200
Message-ID: <82t7ktFlddU1_at_mid.individual.net>

On 17.04.2010 07:33, The Magnet wrote:
> On Apr 16, 5:33 pm, John Hurley<hurleyjo..._at_yahoo.com> wrote:
>> On Apr 16, 6:03 pm, The Magnet<a..._at_unsu.com> wrote:
>>
>> snip
>>
>>> Can you nest DECODE with different field criteria? Here is our
>>> DECODE:
>>
>>> DECODE(SUM(DECODE(subproduct_id, 238, 1, 0)) OVER (PARTITION BY
>>> customer_id),0,'N','Y') ultimate_trader
>>
>>> Now, with that, if the result is Y, meaning that they DO have this 238
>>> product, I want to see if they have a status = 'Active'. So, is there
>>> a way to implement yet another level, testing the status = 'Active' if
>>> the result of the above statement is 'Y'?
>>
>> Did you try testing what you wanted to do?
>>
>> Have you ever heard of inline views?
>
>
> Been trying things, basically it is something like this:
>
> IF product = 238 THEN
> IF status = 'Active' THEN
> x = 'Y'
> ELSE
> x = 'N'
> END IF
> END IF
>
>
> I am looking to put that kind of logic into a SELECT statement.

Did you try nested CASE?

        robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

Received on Sat Apr 17 2010 - 02:51:53 CDT