vbnetcoder
asked on
SQL - pivot SELECT part1, part2, part3, part4 FROM test
how do I pivot this table so I get a new row for each part?
SELECT part1, part2, part3, part4 FROM test
SELECT part1, part2, part3, part4 FROM test
Vitor Montalvão
You need to provide some sample rows so we can help you.
from what we can deduct from the question, the easiest way would be:
SELECT part1 FROM test UNION ALL
SELECT part2 FROM test UNION ALL
SELECT part3 FROM test UNION ALL
SELECT part4 FROM test ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.