If between is inclusive, then if all three values are the same (and I don't
know whether that is possible), wont this result in "bharati, bharati,
bharati"?

Tricky to code with a lack of requirements ;)

-----Original Message-----
From: tweir
[mailto:mssqldba-ezmlmshield-x13454639.[Email address protected]
Sent: 27 February 2006 15:30
To: LazyDBA Discussion
Subject: Re: RE: query required[Scanned]

And since he did say "plz", I will take pity on him. Bear in mind that
I am typing very slowly.

select *,
case when Bharati <= TouchTel and Bharati <= IndiComm then 'Bharati'
when TouchTel <= Bharati and TouchTel <= IndiComm then 'TouchTel'
else 'IndiComm'
end as [First],
case when Bharati Between TouchTel and IndiComm then 'Bharati'
when TouchTel Between Bharati and IndiComm then 'TouchTel'
else 'IndiComm'
end as [Second],
case when Bharati >= TouchTel and Bharati >= IndiComm then 'Bharati'
when TouchTel >= Bharati and TouchTel >= IndiComm then 'TouchTel'
else 'IndiComm'
end as [Third]
from yourtable

Trevor

----- Original Message -----
From: Edwards Ed <mssqldba-ezmlmshield-x5786251.[Email address protected]
Date: Monday, February 27, 2006 7:56 am
Subject: RE: query required[Scanned]
To: LazyDBA Discussion <[Email address protected]

> He did say: "plz"! hehe.
>
>
>
>
> -----Original Message-----
> From: Mayank Agarwal
> [mailto:mssqldba-ezmlmshield-x19089117.[Email address protected]
> Sent: Monday, February 27, 2006 7:54 AM
> To: LazyDBA Discussion
> Subject: RE: query required[Scanned]
>
>
> Very true ..... Seems like abuse of the facility
>
> Regards,
> Mayank Agarwal
>
> CONFIDENTIALITY NOTICE
> This e-mail transmission and any documents, files, or previous e-mail
> messages appended or attached to it, may contain information that is
> confidential or legally privileged. If you are not the intended
> recipient, or a person responsible for delivering it to the intended
> recipient, you are hereby notified that you must not read this
> transmission and that any disclosure, copying, printing, distribution,
> or use of the information contained or attached to this
> transmission is
> STRICTLY PROHIBITED. If you have received this transmission in error,
> please immediately notify the sender by telephone
> (+91.172.2299720) or
> return e-mail message ([Email address protected] and delete the
> originaltransmission, its attachments, and any copies without
> reading or saving
> in any manner. Thank you.
>
> -----Original Message-----
> From: Hugh du Toit
> [mailto:mssqldba-ezmlmshield-x96204084.[Email address protected]
> Sent: Monday, February 27, 2006 6:12 PM
> To: LazyDBA Discussion
> Subject: RE: query required[Scanned]
>
>
> 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
>
>
>
>
>
>
> -------------------------------------------------------------------
> --
> 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
>
>
> Please take a few minutes to provide feedback on the quality of
> service you received. The Department of Education values your
> feedback as a customer. Commissioner John L. Winn is committed to
> continuously assessing and improving the level and quality of
> services provided to you by Department staff. Simply use the link
> below. Thank you in advance for completing the survey.
>
>
> http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address
> protected]
>
> -------------------------------------------------------------------
> --
> 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