I have a table like
| a | 2 |
| b | 3 |
| c | 4 |
| d | 5 |
| a | 4 |
| a | 5 |
| b | 5 |
i would like to change the rows to columns like
| a | 2 | 4 | 5 |
| b | 3 | 5 | |
| c | 4 | ||
| d | 5 |
can you please help me do this.
Columns to rows in sql server 2008
Hi guys,
I have a table like
i would like to change the rows to columns like
can you please help me do this.
I have a table like
i would like to change the rows to columns like
can you please help me do this.
Prasant JinagaPosted Dec 22, 2011, 1:57 AM
You can use Pivot tables to solve.
Thanks,
Prasant