reformating a table

[specialj]

i basically have a table that has stock prices for every day of the last year for a bunch of companies. i need to out put a table with one column for the date and then one column for each stocks price. can you do that with sql? I'm not to familiar with the nuances of the languange.

 

[sleipnir214]

Insufficient data for a meaningful answer.

At the minimum, a description of the datbase schema would be helpful.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[specialj]

Old Table
Name Date Price <--column names
MSFT 6/24 37.5
MSFT 6/23 33
AOL 6/24 22
AOL 6/23 21.3

New Table
Date MSFT AOL <--column names
6/24 37.5 22
6/23 33 21.3

Everything in the tables is a string except for the date which is a date object.

 

[sleipnir214]

There is no single SQL query that can do that.

I recommend you extract the data and insert it using some kind of programming language.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!