Display Table Row as Column

Posted by Guna27 under Sql Server on 4/11/2013 | Points: 10 | Views : 1041 | Status : [Member] | Replies : 2
This is my Table Format


BookID BookName Edition Publisher Category Author
1 ASP.NET 4.0 3rd Edition APRESS Software Engineering James
2 C# 5.0 1st Edition APRESS Software Engineering Helbert
3 Java SE 6 4th Edition Sun Microsystems Software Engineering Goseling
4 JQuery 2nd Edition Microsoft Software Engineering Naughtan
5 Brave New World 3rd Edition APRESS Literature Books Aldous Huxley

I want to display this table format like this,

BookID 1 2 3
BookName ASP.NET 4.0 C# 5.0 Java SE 6
Edition 3rd Edition 1st Edition 4th Edition
Publisher APRESS APRESS Sun Microsystems and so on......
Category Software Engineering Software Engineering Software Engineering
Author James Helbert Goseling

Guna..............


Responses

Posted by: Murugavelmsc on: 4/11/2013 [Member] Starter | Points: 25

Up
0
Down
http://sqlserveradvisor.blogspot.in/2009/03/sql-server-convert-rows-to-columns.html

Regards,
Murugavel S
murugavel.sadagopan@gmail.com
http://murugavelmsc.blogspot.in/

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

Posted by: Guna27 on: 4/11/2013 [Member] Starter | Points: 25

Up
0
Down

BookID BookName Edition
1 ASP.NET 4.0 3rd Edition
2 C# 5.0 1st Edition
3 Java SE 6 4th Edition


I want to display this table format like this,

BookID    1                            2                                 3                

BookName ASP.NET 4.0 C# 5.0 Java SE 6
Edition 3rd Edition 1st Edition 4th Edition


Guna..............

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

Login to post response