How do I convert my column values into row values

Question

0.00/5 (No votes)

See more:

i have a table 'question' with only one column 'ID' like this"

ID

image

multiple_name
a. CH4+ 2O2 ? CO2  + 2H2O
b. 2CH4+ 2O2 ? 2CO2  + 2H2O
c. 3CH4+ 2O2 ? 2CO2  + 3H2O
d. 2CH4+ 2O2 ? 2CO2  + 4H2O

multiple_correct
yes
hint

i want these values to store in rows of specific columns in another table .
for example :
my columns

ID   ans1                        ans2                           ans3                       
1     a. CH4+ 2O2 ? CO2  + 2H2O   b. 2CH4+ 2O2 ? 2CO2  + 2H2O    c. 3CH4+ 2O2 ? 2CO2  + 3H2O

and go on..
can anyone plz help for this??

Posted 22-May-14 20:42pm

muneeba mujeeb

Updated 22-May-14 21:02pm

Aarti Meswania

v2

Add a Solution

Comments

Pranav-BiTwiser 23-May-14 3:06am

Use Pivot..

muneeba mujeeb 23-May-14 3:08am

i cant use pivot bcz pivot requires aggregated func like SUM or MAX but i cant use them in my table

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Arjun Holla · Answer 1 · 2014-05-22T20:57:00

Solution 1

Refer this..

http://stackoverflow.com/questions/10944910/how-to-convert-a-column-header-and-its-value-into-row-in-sql[^]

http://stackoverflow.com/questions/7958036/convert-multi-columns-to-rows[^]

Posted 22-May-14 20:57pm

Arjun Holla

Comments

muneeba mujeeb 23-May-14 3:12am

in above links .. pivot function takes MAX arguement. but i dont need this, i just want to simply show these values against specific columns

Peter Leow · Answer 2 · 2014-05-22T22:29:00

Solution 2

Try this:

SQL

select 1 id,
(select * from question where left(id,1)='a') ans1,
(select * from question where left(id,1)='b') ans2,
(select * from question where left(id,1)='c') ans3,
(select * from question where left(id,1)='d') ans4

Posted 22-May-14 22:29pm

Peter Leow

Comments

muneeba mujeeb 27-May-14 4:47am

i have tried ur solution but it gives me below error :

Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.