How do I convert multiple column values into a single list of row values in SQL Server 2000?
Posted on 2008-10-25
I have data in a table as follows:
ID Answer1 Answer2...Answer15
1 test1 test2... test15
For each record, I want to create a user defined function in SQLServer 2000 that puts the values of each individual column into LIST like:
The purpose of this is so that I can create a radiobuttonlist in asp.net vb so that I can just have a list the user can select an answer for....preferably, I would like to create an Id for each.
Please help...I know there are PIVOT functions in sql server 2005, but I am NOT using 2005...I am using SQL Server 2000
Thanks so much.