how to row wise data show column wise

Posted by Jayakumars under Sql Server on 8/31/2011 | Points: 10 | Views : 4613 | Status : [Member] [MVP] | Replies : 1
hi
how to row wise data show column wise

my record like this

Sunday - column name
=========
Monday
Tuesday
WedNesday
ThursDay
FriDay
Saturday

i need output
monday tuesday , , ,
how will do this.

Mark as Answer if its helpful to you


Responses

Posted by: Vuyiswamb on: 9/2/2011 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
it is called Pivoting, see how its done here

http://www.dotnetfunda.com/articles/article1469-using-order-by-clause-with-columnindex-instead-of-column-name-.aspx

Thank you for posting at Dotnetfunda
[Administrator]

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response