sql server 2008 - Flip SQL Result -

how in sql ?

i have select , result :

1 2 b 3 c 4 d 5 e 

then want result display like

1 2 3 4 5 b c d e 

thanks guys!

you can use pivot

select [1],[2],[3],[4],[5] (   select column1, column2   mytable ) d pivot (   max(column2)   column1 in ([1],[2],[3],[4],[5]) ) piv; 

sql fiddle demo