table values as table header

Question

Hi im getting the result of the following ng Query like this

select Escuser,Eslevel from WF_UserConfiguration  

Escuser     Eslevel
--------------------                                             
A000        1
A010        4
A021        3
ABCD        1
C067        3
C099        1
C252        2

My problem is i want to get the result is like this

 1     2      3     4
---   ---    ---   ---
A000  C252   A021  A010
ABCD         C067 
C099

the table headers 1 2 3 4 are EsLevel values of first query result.How should i get the following result.i mean what query ?? Help me Thanx in advance

Answer 1

Try checking out SQL pivot functionality...