MS SQL 2005 unpivot table.

I have some columns like this:
Column1    Column2     Column3

and I want to display them like this:
ColumnName
Column1
Column2
Column3

With select statement, How can I do?
JameMeckAsked:
Who is Participating?
 
cyberkiwiCommented:
select convert(nvarchar(max),Column1) from table1
union all
select Column2 from table1
union all
select Column3 from table1
0
 
JameMeckAuthor Commented:
Thanks! I got it
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.