By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,266 Members | 1,312 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,266 IT Pros & Developers. It's quick & easy.

How to convert rows into different columns

P: 31
How to convert rows into different columns

Thanks in advance
Nov 20 '09 #1
Share this Question
Share on Google+
2 Replies


ssnaik84
100+
P: 149

nbiswas
100+
P: 149
It can be achieved in more than I way..depending on the situation.
Prior to PIVOT & UNPIVOT available since Sql Server 2005, the row column transposition was done by using case statement(among other alternatives).

Have a look

Pivot Table Data in SQL Server 2000 and 2005
Nov 21 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.