how can i display the data like this

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 2008 Forums

Transact-SQL (2008)

how can i display the data like this

Author

Topic

boreddy
Posting Yak Master

172 Posts

Posted - 2015-02-24 : 01:43:15

Hi Experts
I have the data like this
1 1 b1
1 2 b2
1 3 b3
1 4 b4
2 1 a1
2 2 a2
2 3 a3
2 4 a4
3 1 c1
3 2 c2
3 3 c3
3 4 c4

I want to display like this
b1 b2 b3 b4
1 1 1 1
1 2 3 4
a1 a2 a3 a4
1 1 1 1
1 2 3 4
c1 c2 c3 c4
1 1 1 1
1 2 3 4

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources