You're absolutely right! That's what happens when we "plz do fast"
without requirements!

----- Original Message -----
From: Futcher John <mssqldba-ezmlmshield-
x31145266.[Email address protected]
Date: Monday, February 27, 2006 10:46 am
Subject: RE: RE: query required[Scanned]
To: LazyDBA Discussion <[Email address protected]

> 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
>
>
> -------------------------------------------------------------------
> --
> 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