Archives of the TeradataForum

Message Posted: Fri, 06 Sep 2002 @ 14:39:50 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Thanks every one for your help. I found an easy way to do:

select line_act_mth,

       sum(case when line_act_mth = '2'
               and cycle_mth in ('4','5','6')
               then 1
               else 0
               end ) AS FEB_KOUNT,

       sum(case when line_act_mth = '3'
               and cycle_mth in ('5','6','7')
               then 1
               else 0
               end ) AS MAR_KOUNT,

       sum(case when line_act_mth = '4'
               and cycle_mth in ('6','7','8')
               then 1
               else 0
               end ) AS APR_KOUNT

from ( select cust_id, cust_line_seq_id, extract (month from cycle_dt) AS cycle_mth1,
              extract (month from LINE_ACT_DT) AS line_act_mth1

             from SDW_PRDUSR_ALLVM.VISION_P2K_ACTS_V

             where LINE_ACT_DT between '2002-02-01' and '2002-04-30'
             and CYCLE_DT BETWEEN '2002-04-01' and '2002-08-30'
             group by 1,2,3,4) Derived(cust_id, cust_line_seq_id, cycle_mth, line_act_mth)

group by 1
order by 1

Thank you,

Arun

	<Prev	Next>		<<First	<Prev	Next>	Last>>