Re: RE: RE: RE: query required[Scanned]

Re: RE: RE: RE: query required[Scanned]

 

  

Always glad to be of service!

Trevor

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

> tweir,
> We thank you for your support, again. hehe.
>
>
> -----Original Message-----
> From: tweir
> [mailto:mssqldba-ezmlmshield-x79104134.[Email address protected]
> Sent: Monday, February 27, 2006 10:50 AM
> To: LazyDBA Discussion
> Subject: Re: RE: RE: query required[Scanned]
>
>
> 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
> >
>
>
> -------------------------------------------------------------------
> --
> 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
>

MS Sql Server LazyDBA home page