Foooooooooorrrrrrrrrrrr a loooooooooooonnnnnnnnnnngggggggggggggg,
looooooooooooonnnnnnnnnnnnggggggggggg tiiiiiiiiiiiiimmmmmmmmmmmmeeeeeeeeeee!
Trevor
-----Original Message-----
From: Edwards Ed
[mailto:mssqldba-ezmlmshield-x64191299.[Email address protected]
Sent: Monday, February 27, 2006 11:02 AM
To: LazyDBA Discussion
Subject: RE: RE: query required[Scanned]
Christopher,
Youuuuuuuuuuuuuuuuu willlllllllllllllllll haveeeeeeeeeeeeeeeeee
tooooooooooooooooooo waittttttttttttttttt!
heheeeeeeeeeeeeeeeeeeeeeeeeeeeeee!
-----Original Message-----
From: Bellizzi Christopher - IBG
[mailto:mssqldba-ezmlmshield-x44697621.[Email address protected]
Sent: Monday, February 27, 2006 10:59 AM
To: LazyDBA Discussion
Subject: RE: RE: query required[Scanned]
Hey Trevor' I need help plz, i am introuble. I need 2500 + DTS packages
converted to SQL Server 2005 .. Fast, chop chop, he he
Christopher Bellizzi
SQL DBA/Programmer
240 Falls Street
Seneca Falls, NY 13148
Phone: (315) 568-7886
Email: Christopher.[Email address protected]
-----Original Message-----
From: Edwards Ed
[mailto:mssqldba-ezmlmshield-x48689559.[Email address protected]
Sent: Monday, February 27, 2006 10:49 AM
To: LazyDBA Discussion
Subject: RE: RE: query required[Scanned]
tweir,
We thank you for your support! hehe.
-----Original Message-----
From: tweir
[mailto:mssqldba-ezmlmshield-x13454639.[Email address protected]
Sent: Monday, February 27, 2006 10:30 AM
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
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
************************************
This e-mail and any files transmitted with it are proprietary and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this e-mail in error please notify the sender. Please
note that any views or opinions presented in this e-mail are solely those of
the author and do not necessarily represent those of ITT Industries, Inc.
The recipient should check this e-mail and any attachments for the presence
of viruses. ITT Industries accepts no liability for any damage caused by any
virus transmitted by this e-mail.
************************************
---------------------------------------------------------------------
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