Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
baaul
Starting Member
16 Posts |
 Posted - 2005-10-02 : 23:00:15
|
| Is there a way to PIVOT Strings from "Answer" column... For Example:BookId SheetId Answer-------- ------- ---------------------------------------------------------------------------------------------------E06R 001 2 2 1122 2E06R 002 2 2 2convert to:BookId SheetId Answer------ ------- -----------------------------------------------------------------------------------------------------E06R 001 2 E06R 001 E06R 001 2E06R 001 E06R 001 1E06R 001 1E06R 001 2E06R 001 2E06R 001 E06R 001 2E06R 002 2E06R 002 E06R 002 2 E06R 002 E06R 002 2 e.t.c....If there's no easy way, what kind of procedure can I use to achieve this? Please give detailed info on this, it's a SQL Server 2000 table I'm trying to PIVOT and load into. Thanks in advance.-baaul |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
|
|
|
|
|
PIVOT a Colum into Rows