Yes. "plz do fast" will guaranteed not get you fast results.


-----Original Message-----
From: Paul Ho [mailto:mssqldba-ezmlmshield-x25446067.[Email address protected]
Sent: Monday, February 27, 2006 14:30 PM
To: LazyDBA Discussion
Subject: RE: query required[Scanned]

Geez, who's doing the work and who's getting paid here, no wonder it's
called lazydba


-----Original Message-----
From: Pawan Singh
[mailto:mssqldba-ezmlmshield-x73560504.[Email address protected]
Sent: February 27, 2006 7:06 AM
To: LazyDBA Discussion
Subject: query required


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




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





MS Sql Server LazyDBA home page