Re: would you please check this for me?
Date: Thu, 3 Jan 2008 13:26:46 -0800 (PST)
Message-ID: <dbc7ef9c-10bb-4aea-8ce2-48ee5810a638@f3g2000hsg.googlegroups.com>
On Jan 3, 3:43 pm, Totti <saliba.toufic.geo..._at_gmail.com> wrote:
> hi all, i ve been struggeling with this function and i can not see
> what is the problem.
> i am using it for getting the following result:
> **********************************************************************************************************
> Month Year SP-20.2 SP-20.1 SP-20.6
> ----- --- ---------- ---------- ----------
> 01 1998 400 140 80
> 02 1998 0 0 0
> 03 1998 0 0 99
> 04 1998 0 163 0
> 05 1998 420 0 90
> 06 1998 0 0 0
> 07 1998 0 155 88
> 08 1998 0 151 85
> 09 1998 481 145 81
> 10 1998 0 0 0
> 11 1998 0 0 110
> 12 1998 0 0 0
> 01 1999 0 0 89
> 02 1999 456 163 86
> 03 1999 0 0 81
> 04 1999 0 0 0
> 05 1999 0 162 87
> 06 1999 413 0 90
> 07 1999 0 0 0
>
> **********************************************************************************************************
> and the formula is:
> **********************************************************************************************************
> SELECT TO_CHAR(purinv.Inv_Date,'mm')
> MONTH ,TO_CHAR(purinv.Inv_Date,'YYYY') YEAR,
> (case when purch.Prod_Code = 'SP-20.2' then sum(nvl(purch.qty,0)) else
> sum(0) end SP-20.2,
> case when purch.Prod_Code = 'SP-20.1' then sum(nvl(purch.qty,0)) else
> sum(0) end SP-20.1,
> case when purch.Prod_Code = 'SP-20.6' then sum(nvl(purch.qty,0)) else
> sum(0)end SP-20.6)
> from purinv, purch
> where purinv.Code = purch.Inv_Code and purch.Prod_Code in ('SP-20.2',
> 'SP-20.1', 'SP-20.6')
> group by TO_CHAR(purinv.Inv_Date,'mm')
> MONTH ,TO_CHAR(purinv.Inv_Date,'YYYY') ,purch.Prod_Code
> order by TO_CHAR(purinv.Inv_Date,'mm')
> MONTH ,TO_CHAR(purinv.Inv_Date,'YYYY')
>
> Thank you for helping.
You are getting output ... what kind of problem are you experiencing?
What business logic are you trying to accomplish exactly?
Why is the data from 1998 and 1999 this looks suspiciously like some kind of homework perhaps? Received on Thu Jan 03 2008 - 15:26:46 CST