By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,227 Members | 1,026 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,227 IT Pros & Developers. It's quick & easy.

Convert rows to column

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
Try this thread:
<URL:http://groups.google.com/group/comp.databases.ibm-db2/browse_frm/thread/f36aa9d4fc03f95a>

B.

May 3 '06 #2

P: n/a
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.