Re: Data format and display

Hello Steve,

El 20/01/2005 5:20 PM, Steve Crawford en su mensaje escribio:
> select
>   zert_title as TITULO,
>   sum(case when epr_mes=200309 then epr_valor else 0 end) as "200309",
>   sum(case when epr_mes=200310 then epr_valor else 0 end) as "200310",
>   sum(case when epr_mes=200311 then epr_valor else 0 end) as "200311",
>   sum(case when epr_mes=200312 then epr_valor else 0 end) as "200312"
>   group by 1;

That works ok, but start and end month are variables, user can choose them.

Thanks,


--
Sinceramente,
Josué Maldonado.

"Los estupidos adolecentes son los que se reunen por las noches a
consumir drogas y a planear los ilicitos."