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
MS Sql Server LazyDBA home page