467,185 Members | 1,207 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,185 developers. It's quick & easy.

Convert rows to column

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.

May 3 '06 #1
  • viewed: 2439
Share:
2 Replies
Try this thread:
<URL:http://groups.google.com/group/comp.databases.ibm-db2/browse_frm/thread/f36aa9d4fc03f95a>

B.

May 3 '06 #2
ggnanaraj wrote:
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.

This question was asked and answered here just two weeks ago:
http://www.thescripts.com/forum/thread481273.html
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
May 3 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Fan Ruo Xin | last post: by
reply views Thread by May | last post: by
8 posts views Thread by s_wadhwa@berkeley.edu | last post: by
2 posts views Thread by kirke | last post: by
9 posts views Thread by myotheraccount | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.