Hi Gurus,
plz help me out, i am introuble....

i have data like

ID MinValue Bharati TouchTel IndiComm
101 1 2 5 1
102 5 5 6 8
102 2 3 2 8
102 3 5 3 8


I need Like
ID MinValue Bharati TouchTel IndiComm First Second Third
101 1 2 5 1 IndiComm Bharti TouchTell
102 5 5 6 8 Bharati TouchTell IndiComm
102 2 3 2 8 TouchTell Bharati IndiComm
102 3 8 3 5 TouchTell IndiComm Bharati

plz do fast
any input is appreciated

Thanks in advance..

Kind Regards,

Pawan Singh


MS Sql Server LazyDBA home page