subject:"\[GENERAL\] Rows to columns"

Re: [GENERAL] Rows to columns

2004-02-24 Thread Joe Conway

Josué Maldonado wrote: The problem is I need show the data in this way: TIPOOCT03NOV03DIC03ENE04FEB04 NQTY 490 360 950 700 500 NSOLD46003900710062005000 NCOST18501760300

[GENERAL] Rows to columns

2004-02-24 Thread Josué Maldonado

Hello List, I have a table that look like this: create table estad (nprodfk int, cmes char(6), hmes char(5), nqty numeric(12,2), nsold numeric(12,5), ncost numeric(12,2)); It contains this data: insert into estad values (25,'200402','FEB04',500,5000,2300); insert into estad values (25,'200401','