Convert rows to column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ggnanaraj - 03 May 2006 11:56 GMT

I have the following table contents:
MONTH STATES
----------- ----------------------
1 5177
2 640
3 6029
4 11086
5 2131

I need to convert this to:

MONTH 1 2 3 4
5

STATES 5177 640 6029 11086
2131

How can I do this?

TIA.

Reply to this Message

Brian Tkatch - 03 May 2006 14:58 GMT

Try this thread:
<URL:http://groups.google.com/group/comp.databases.ibm-db2/browse_frm/thread/f36aa9d4
fc03f95a>

B.

Reply to this Message

Serge Rielau - 03 May 2006 16:45 GMT

> I have the following table contents:
> MONTH STATES
[quoted text clipped - 16 lines]
>
> TIA.

This question was asked and answered here just two weeks ago:
http://www.thescripts.com/forum/thread481273.html

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message