Querying Recordsets 1

[Sveno]

Hi,

I have created a recordset which when put in a simple table returns values as such:

Year Code Value
1999 A 100
1999 B 25
1999 C 27
2000 A 85
2000 B 115
2000 C 45

Is there some way to manipulate the output to?:

Code 1999 2000
A 100 85
B 25 115
C 27 45

Someone suggested I could use Java and make an array, but I have only used ASP and have no experience in Java.

Thank you

Cheers

Mark Svensson

 

[shaddow]

Can you place the A B C in other table?
If so i could help you by using SHAPES... ________
George, M

 

[Sveno]

Hi George,

Thank you for replying. Unfortunately the query comes from a single table (15 million rows) in an ORACLE database of which I have read-only access through ODBC.

I do have a local database (Sybase SQL Anywhere) on the server however, and I was thinking last night that I could update a temporary summary table in this database from the ORACLE database. I could then use a link to reference the details for each row from the ORACLE database. (Using Code and Year together)

I have no knowledge of SHAPES though, is there a handy reference site?

Cheers

Mark Svensson

 

[shaddow]

Try

http://www.devguru.com

Hope this helps...
________
George, M

 

[shaddow]

or look at the

http://www.msdn.microsoft.com

Hope this helps...
________
George, M

 

[Sveno]

Hi George,

I have had a quick look at the Dev Guru site this morning, thank you for the lead, I have not been there before. I am looking forward to going through the advanced SQL functions.

I am now using summary tables in my Sybase database, so at least I have a solution.

In any case, I finally had a win here and now have a budget for a NT server and SQL Server, so I can build a data warehouse. I can then hold summary and detailed tables from the ORACLE database and populate them overnight.

Cheers

Mark Svensson

 

[shaddow]

It's a good ideea to migrate on NT or W2000 and SQL Server...
Good luck. ________
George, M