List:General Discussion« Previous MessageNext Message »
From:Jinsoo Hwang Date:September 22 2000 11:35pm
Subject:Table conversion ??
View as plain text  
Hi,

I have a following table.

 create table d_quotes (
   com_code  char(12),
   q_day         date,
   c_price       int
   )

There are around 1500 distinct com_code(company code) and
daily closing price(c_price) of their stocks are coded from
19830304-20000904(q_day).

What I am trying to do is to make a new table (day by com_code)
after 19970101.
Say,
--------------
                  code_1       code_2 .....   code_1500
19970104     c_price
19970105        ....
.....
---------------
Any help ?

Jinsoo Hwang

Thread
Table conversion ??Jinsoo Hwang23 Sep