Display Table Row as Column

Posted by Guna27 under Sql Server on 4/11/2013 | Points: 10 | Views : 1883 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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..............

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

Latest Posts