Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Modifyinig the way data is displayed.

Author  Topic 

dfs3000my
Starting Member

9 Posts

Posted - 2009-01-22 : 02:45:32
Hi all,

I would want to modify the way my data is being displayed. Current it is being displayed vertically, I would like it to be displayed horizontally. Is it possible? Below is how my data looks like.



And I would like it to be something like


bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2009-01-22 : 03:39:16
use unpivot function
Go to Top of Page

karthickbabu
Posting Yak Master

151 Posts

Posted - 2009-01-22 : 04:44:45


http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/

====================================================
you realize you've made a mistake, take immediate steps to correct it.
Go to Top of Page
   

- Advertisement -