i need sql query like this following

Posted by Jayakumars under Regular Expressions on 7/14/2011 | Points: 10 | Views : 1251 | Status : [Member] [MVP] | Replies : 3
id Days
1 Sun
2 Mon
3 Tue

i need this is row wise i need this record column wise how to achieve this

Mark as Answer if its helpful to you


Responses

Posted by: Jpchoudhari on: 7/14/2011 [Member] Starter | Points: 25

Up
0
Down
Hi,

Refer this
http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/
http://blog.sqlauthority.com/2008/05/22/sql-server-pivot-table-example/
http://www.techrepublic.com/article/write-pivot-queries-in-sql-server-2005/6143761

Regards,
Jaydeep

Kind Regards,
Jaydeep

Kind Regards,
Jay

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

Posted by: Lakn2 on: 7/14/2011 [Member] Starter | Points: 25

Up
0
Down
Refer Pivot table,unpivot Syntax in sql server 2005

Thanks&Regards
LakshmiNarayana Nalluri.

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

Login to post response