public inbox for [email protected]
help / color / mirror / Atom feedFrom: Shane Borden <[email protected]>
To: Tchouante, Merlin <[email protected]>
Cc: JORGE MALDONADO <[email protected]>
Cc: [email protected]
Subject: Re: Query with conditional statement
Date: Wed, 13 Sep 2023 16:39:49 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <DM4PR12MB511902103147E02227761C66D2F0A@DM4PR12MB5119.namprd12.prod.outlook.com>
References: <DM4PR12MB511902103147E02227761C66D2F0A@DM4PR12MB5119.namprd12.prod.outlook.com>
--Apple-Mail-8819A634-8043-40FC-82F1-B41CF20DB9B4
Content-Type: text/html;
charset=utf-8
Content-Transfer-Encoding: quoted-printable
<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto">You will need to do a CASE statement for ea=
ch column. I=E2=80=99m not aware of being able to return multiple colu=
mns from one case. <br><br><div dir=3D"ltr">Shane Borden<div>sborden76@=
gmail.com<br><div>Sent from my iPhone</div></div></div><div dir=3D"ltr"><br>=
<blockquote type=3D"cite">On Sep 13, 2023, at 4:23 PM, Tchouante, Merlin <=
;[email protected]> wrote:<br><br></blockquote></div><blockquote typ=
e=3D"cite"><div dir=3D"ltr">=EF=BB=BF
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii">=
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style>@font-face { font-family: "Cambria Math"; }
@font-face { font-family: Calibri; }
@font-face { }
@font-face { font-family: "Segoe UI"; }
p.MsoNormal, li.MsoNormal, div.MsoNormal { margin: 0in; font-size: 11pt; fon=
t-family: Calibri, sans-serif; }
a:link, span.MsoHyperlink { color: blue; text-decoration: underline; }
span.EmailStyle19 { font-family: Calibri, sans-serif; color: rgb(31, 56, 100=
); font-weight: normal; font-style: normal; }
.MsoChpDefault { font-size: 10pt; }
@page WordSection1 { size: 8.5in 11in; margin: 1in; }
div.WordSection1 { page: WordSection1; }</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span style=3D"color:#1F3864">Yes, it can.<o:p></o:p>=
</span></p>
<p class=3D"MsoNormal"><span style=3D"color:#1F3864"><o:p> </o:p></span=
></p>
<div>
<p class=3D"MsoNormal" style=3D"background:white"><b><i><span style=3D"font-=
size:10.0pt;font-family:inherit;color:teal;border:none windowtext 1.0pt;padd=
ing:0in">Thanks,</span></i></b><span style=3D"color:#242424"><o:p></o:p></sp=
an></p>
<p class=3D"MsoNormal" style=3D"background:white"><b><i><span style=3D"font-=
size:10.0pt;font-family:inherit;color:black;border:none windowtext 1.0pt;pad=
ding:0in"> -- Merlin</span></i></b><span style=3D"color:#242424"><o:p>=
</o:p></span></p>
<p class=3D"MsoNormal" style=3D"background:white"><span style=3D"color:#1F38=
64;border:none windowtext 1.0pt;padding:0in"> </span><span style=3D"col=
or:#242424"><o:p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"background:white"><span style=3D"color:#1F38=
64;border:none windowtext 1.0pt;padding:0in"> </span><span style=3D"col=
or:#242424"><o:p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"background:white"><b><i><span style=3D"font-=
size:9.0pt;font-family:inherit;color:black;border:none windowtext 1.0pt;padd=
ing:0in">Merlin D. Tchouante,</span></i></b><span style=3D"font-size:9.0pt;f=
ont-family:inherit;color:black;border:none windowtext 1.0pt;padding:0in">&nb=
sp;</span><span style=3D"font-size:9.0pt;font-family:inherit;color:maroon;bo=
rder:none windowtext 1.0pt;padding:0in">Sr.
IT Enterprise Application Developer</span><span style=3D"font-size:9.0pt;fo=
nt-family:inherit;color:navy;border:none windowtext 1.0pt;padding:0in"><br>
</span><b><i><span style=3D"font-size:9.0pt;font-family:"Arial",sa=
ns-serif;color:red;border:none windowtext 1.0pt;padding:0in">Center for Info=
rmation Technology Services (CITS)</span></i></b><span style=3D"font-size:9.=
0pt;font-family:inherit;color:navy;border:none windowtext 1.0pt;padding:0in"=
><br>
</span><i><span style=3D"font-size:9.0pt;font-family:"Arial",sans-=
serif;color:navy;border:none windowtext 1.0pt;padding:0in">601 West Lombard S=
treet</span></i><span style=3D"font-size:9.0pt;font-family:inherit;color:nav=
y;border:none windowtext 1.0pt;padding:0in"><br>
</span><i><span style=3D"font-size:9.0pt;font-family:"Arial",sans-=
serif;color:navy;border:none windowtext 1.0pt;padding:0in">Baltimore, Maryla=
nd 21201-1512</span></i><span style=3D"font-size:9.0pt;font-family:inherit;c=
olor:navy;border:none windowtext 1.0pt;padding:0in"><br>
</span><span style=3D"color:#1F3864"><a href=3D"mailto:[email protected]=
u" title=3D"mailto:[email protected]"><i><span style=3D"font-family:&qu=
ot;Arial",sans-serif">[email protected]</span></i></a></span><span=
style=3D"font-size:9.0pt;font-family:inherit;color:black;border:none window=
text 1.0pt;padding:0in"> <br>
</span><span style=3D"color:#1F3864">410-706-4489 * 410-706-1500 fax</span><=
span style=3D"color:#242424"><o:p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"background:white"><span style=3D"font-size:9=
.0pt;font-family:"Arial",sans-serif;color:teal;border:none windowt=
ext 1.0pt;padding:0in"> </span><span style=3D"color:#242424"><o:p></o:p=
></span></p>
<p class=3D"MsoNormal" style=3D"background:white"><i><span style=3D"font-siz=
e:9.0pt;font-family:inherit;color:#1F3864;border:none windowtext 1.0pt;paddi=
ng:0in">Please send Blackboard questions to the CITS support email address:<=
/span></i><span style=3D"font-size:9.0pt;font-family:inherit;color:#1F3864;b=
order:none windowtext 1.0pt;padding:0in"> <a href=3D"mailto:dl-ci=
[email protected]">[email protected]</a></span><span st=
yle=3D"color:#242424"><o:p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"background:white"><i><span style=3D"font-siz=
e:9.0pt;font-family:inherit;color:#365F91;border:none windowtext 1.0pt;paddi=
ng:0in">Please send Mediasite questions to the CITS support email address:</=
span></i><span style=3D"font-size:9.0pt;font-family:inherit;color:#365F91;bo=
rder:none windowtext 1.0pt;padding:0in"> </span><span style=3D"fo=
nt-size:9.0pt;font-family:inherit;color:#1F3864;border:none windowtext 1.0pt=
;padding:0in"><a href=3D"mailto:[email protected]">DL-CI=
[email protected]</a></span><span style=3D"color:#1F3864"><o:=
p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"background:white"><span style=3D"color:#1F38=
64;border:none windowtext 1.0pt;padding:0in"> </span><span style=3D"col=
or:#242424"><o:p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"background:white"><span style=3D"color:#1F38=
64"><div><image001.png></div></span><span style=3D"color:#242424"><o:p=
></o:p></span></p>
</div>
<p class=3D"MsoNormal"><span style=3D"color:#1F3864"><o:p> </o:p></span=
></p>
<div>
<div style=3D"border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0=
in 0in">
<p class=3D"MsoNormal"><b>From:</b> JORGE MALDONADO <[email protected]=
om> <br>
<b>Sent:</b> Wednesday, September 13, 2023 1:52 PM<br>
<b>To:</b> [email protected]<br>
<b>Subject:</b> Query with conditional statement<o:p></o:p></p>
</div>
</div>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<table class=3D"MsoNormalTable" border=3D"0" cellspacing=3D"0" cellpadding=3D=
"0" align=3D"left" width=3D"100%" style=3D"width:100.0%">
<tbody>
<tr>
<td style=3D"background:#A6A6A6;padding:5.25pt 1.5pt 5.25pt 1.5pt"></td>
<td width=3D"100%" style=3D"width:100.0%;background:#EAEAEA;padding:5.25pt 3=
.75pt 5.25pt 11.25pt">
<div>
<p class=3D"MsoNormal" style=3D"mso-element:frame;mso-element-frame-hspace:2=
.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-elem=
ent-anchor-horizontal:column;mso-height-rule:exactly">
<span style=3D"font-size:9.0pt;font-family:"Segoe UI",sans-serif;c=
olor:#212121">You don't often get email from
<a href=3D"mailto:[email protected]">[email protected]</a>. <a hre=
f=3D"https://aka.ms/LearnAboutSenderIdentification";
Learn why this is important</a><o:p></o:p></span></p>
</div>
</td>
<td width=3D"75" style=3D"width:56.25pt;background:#EAEAEA;padding:5.25pt 3.=
75pt 5.25pt 3.75pt;align:left">
</td>
</tr>
</tbody>
</table>
<div>
<p class=3D"MsoNormal" align=3D"center" style=3D"mso-margin-top-alt:auto;mso=
-margin-bottom-alt:auto;text-align:center;line-height:12.0pt;background:#FFE=
B9C">
<b><span style=3D"font-size:10.0pt;color:red">CAUTION: </span></b><span styl=
e=3D"font-size:10.0pt;color:black">This message originated from a non-UMB em=
ail system. Hover over any links before clicking and use caution opening att=
achments.</span><o:p></o:p></p>
<div>
<div>
<p class=3D"MsoNormal">Hi, <o:p></o:p></p>
<div>
<p class=3D"MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class=3D"MsoNormal">Can a conditional CASE statement be part of the SELEC=
T portion of a query? For example:<o:p></o:p></p>
</div>
<div>
<p class=3D"MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class=3D"MsoNormal">SELECT<o:p></o:p></p>
</div>
<div>
<p class=3D"MsoNormal">fld1, fld2, fld3,<o:p></o:p></p>
</div>
<div>
<p class=3D"MsoNormal">CASE <o:p></o:p></p>
</div>
<div>
<p class=3D"MsoNormal"> WHEN condition1 THEN fldx1 AS a1, fldx2=
AS a2, fldx3 AS a3<o:p></o:p></p>
</div>
<div>
<p class=3D"MsoNormal"> WHEN condition2 THEN fldy1 AS b1, f=
ldy2 AS b2, fldy3 AS b3<o:p></o:p></p>
</div>
<div>
<p class=3D"MsoNormal"> ELSE .....<o:p></o:p></p>
</div>
<div>
<p class=3D"MsoNormal">END,<o:p></o:p></p>
</div>
<div>
<p class=3D"MsoNormal">fld6, fld7<o:p></o:p></p>
</div>
<div>
<p class=3D"MsoNormal">FROM ......<o:p></o:p></p>
</div>
<div>
<p class=3D"MsoNormal">WHERE ......<o:p></o:p></p>
</div>
<div>
<p class=3D"MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class=3D"MsoNormal">I ran a test and see the following:<o:p></o:p></p>
</div>
<div>
<p class=3D"MsoNormal">* Each WHEN only accepts 1 result and not 3 as shown i=
n the example<o:p></o:p></p>
</div>
<div>
<p class=3D"MsoNormal">* The AS for the alias is not supported<o:p></o:=
p></p>
</div>
<div>
<p class=3D"MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class=3D"MsoNormal">I need to return more than 1 field on each WHEN and a=
lso assign an ALIAS.<o:p></o:p></p>
</div>
<div>
<p class=3D"MsoNormal">I very much appreciate your feedback.<o:p></o:p></p>
</div>
<div>
<p class=3D"MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class=3D"MsoNormal">Regards,<o:p></o:p></p>
</div>
<div>
<p class=3D"MsoNormal">Jorge Maldonado<o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div></blockquote></body></html>=
--Apple-Mail-8819A634-8043-40FC-82F1-B41CF20DB9B4--
view thread (5+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Query with conditional statement
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox