How can I show column value in a row

Question

Hi I want to show column value in single row. Is it possible? If it isthen how will I do it. Thanks in advance

Lalit M · Answer

You can show column values in a table in a single row.try to below code sample.. select * from dbo.Split('vitA vitB vitA protein vitBvitA''')

Pravin More · Answer

Hi James Yes it is possible to show column as Row....You can Use PIVOT for it. here is demo.................. http://www.simple-talk.com/community/blogs/andras/archive/2007/09/14/37265.aspx hope u solve it. Thanx Pravin.