× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. August 2010

Re: This list

Email1 came before email2 and shouldn't have




Rob Berendt
Received: from mail165.messagelabs.com ([216.82.253.147])
by NS1.dekko.com (Lotus Domino Release 8.5.1FP3)
with ESMTP id 2010081814142197-3907 ;
Wed, 18 Aug 2010 14:14:21 -0400
X-VirusChecked: Checked
X-Env-Sender: midrange-l-bounces@xxxxxxxxxxxx
X-Msg-Ref: server-15.tower-165.messagelabs.com!1282155257!32584672!1
X-StarScan-Version: 6.2.4; banners=-,-,-
X-Originating-IP: [69.3.23.26]
X-SpamReason: No, hits=0.0 required=7.0 tests=
Received: (qmail 27299 invoked from network); 18 Aug 2010 18:14:18 -0000
Received: from mailout.midrange.com (HELO mailout.midrange.com) (69.3.23.26)
by server-15.tower-165.messagelabs.com with DHE-RSA-AES256-SHA encrypted SMTP; 18 Aug 2010 18:14:18 -0000
Received: from rivendell.midrange.com (localhost [127.0.0.1])
by mailout.midrange.com (8.14.3/8.14.3) with ESMTP id o7IIAQSY029629;
Wed, 18 Aug 2010 13:10:26 -0500
X-DomainKeys: Sendmail DomainKeys Filter v1.0.0 mailout.midrange.com o7IIAQSY029629
DomainKey-Signature: a=rsa-sha1; s=dk; d=midrange.com; c=simple; q=dns;
b=RC4PTCj90UgsCgCTduaibU+c2XgVWFmgn6ILJ/xah2CKmo4Bfd5FVibDEEGwZEu+6
ZnLzsuqrB4nXcnn0p7NPg==
X-DKIM: Sendmail DKIM Filter v2.8.3 mailout.midrange.com o7IIAQSY029629
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=midrange.com;
s=midrange; t=1282155051;
bh=googI823bMuKJSe3Bn0itsT7MX79GiAbTs/ejrn2F8M=;
h=MIME-Version:Subject:Date:Message-ID:In-Reply-To:References:From:
To:Reply-To:List-Id:List-Unsubscribe:List-Archive:List-Post:
List-Help:List-Subscribe:Content-Type:Content-Transfer-Encoding:
Sender;
b=Yf3DZPfTQ9hmzX2ri7NLljDK8f9HjjdNwRSAhNLNVFxwk+jkj7jxqCekhWUXIoWPG
lYt529FeTtBJ4RRkIX+tDzCqKLoot6W9u5QCRJzT+nY9NcIKOr3kuEOgO+yn+SEz1v
7Ytr9KjrGSXqo0pzqq8y3sL2Zl3bJbqexm/FGwtk=
Received: from mail.rgcweb.org (wsip-98-190-207-47.rn.hr.cox.net
[98.190.207.47])
by mailout.midrange.com (8.14.3/8.14.3) with ESMTP id o7IIAFxf029533
for <midrange-l@xxxxxxxxxxxx>; Wed, 18 Aug 2010 13:10:21 -0500
Received: from mail.rgcweb.org ([192.168.0.17]) by mail.rgcweb.org with
Microsoft SMTPSVC(6.0.3790.4675); Wed, 18 Aug 2010 14:11:42 -0400
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4657
MIME-Version: 1.0
Subject: RE: Multiple condition sql
Date: Wed, 18 Aug 2010 14:11:43 -0400
Message-ID: <B369FBDD3799E14CB310EF780B6EBC7B050B578C@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
In-Reply-To: <5AF028844A375D4B98FDCB0627C9AA19064B7BD5@xxxxxxxxxxxxxxxxxxxxxxx>
Importance: Normal
X-MS-Has-Attach:
Priority: normal
X-MS-TNEF-Correlator:
Thread-Topic: Multiple condition sql
Thread-Index: Acs++/eyqiRyjHsyRW2qpnw3HiqvNAAAevnQAAC1xYA=
References: <B369FBDD3799E14CB310EF780B6EBC7B050B5789@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
<5AF028844A375D4B98FDCB0627C9AA19064B7BD5@xxxxxxxxxxxxxxxxxxxxxxx>
From: "Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
X-OriginalArrivalTime: 18 Aug 2010 18:11:42.0980 (UTC)
FILETIME=[CFD84C40:01CB3F00]
X-Virus-Scanned: clamav-milter 0.96.1 at rivendell.midrange.com
X-Virus-Status: Clean
X-BeenThere: midrange-l@xxxxxxxxxxxx
X-Mailman-Version: 2.1.9
Precedence: list
Reply-To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
List-Id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
Auto-Submitted: auto-generated
List-Unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>,
<mailto:midrange-l-request@xxxxxxxxxxxx?subject=unsubscribe>
List-Archive: <http://archive.midrange.com/midrange-l>
List-Post: <mailto:midrange-l@xxxxxxxxxxxx>
List-Help: <mailto:midrange-l-request@xxxxxxxxxxxx?subject=help>
List-Subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>,
<mailto:midrange-l-request@xxxxxxxxxxxx?subject=subscribe>
Sender: midrange-l-bounces@xxxxxxxxxxxx
Errors-To: midrange-l-bounces@xxxxxxxxxxxx
X-MIMETrack: Itemize by SMTP Server on INTERNOTES/DEKKO(Release 8.5.1FP3|May 23, 2010) at
08/18/2010 14:14:22,
Serialize by Notes Client on Rob Berendt/DEKKO(Release 8.5.1 FP3|May 24, 2010) at
08/18/2010 02:42:29 PM,
Serialize complete at 08/18/2010 02:42:29 PM
Content-Transfer-Encoding: 7bit
Content-class: urn:content-classes:message
Content-Type: text/plain; charset="us-ascii"

Thanks Paul
I have never used 'case' in an SQL statement.

Mike

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Morgan, Paul
Sent: Wednesday, August 18, 2010 1:59 PM
To: Midrange Systems Technical Discussion
Subject: RE: Multiple condition sql

Something like this will update all three fields on all records. If the
flag isn't set that field is updated with the same value:

update contract_file
Set emp = case when empflag = 'Y'
then newUser
else emp
end,
contact1 = case when contflag1 = 'Y'
then newUser
else contact1
end,
contact2 = case when contflag2 = 'Y'
then newUser
else contact2
end

Paul Morgan

Principal Programmer Analyst
IS Supply Chain/Replenishment


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Smith, Mike
Sent: Wednesday, August 18, 2010 1:37 PM
To: Midrange Systems Technical Discussion
Subject: Multiple condition sql

I'm trying to figure out if the following 3 sql statements can be
combined into 1 statement.

I'm trying to update 1 file and set specific field based on flagged
variables from a display file.

Update contract_file set emp = newUser where empflag = 'Y'
Update contract_file set contact1 = newUser where contflag1 = 'Y'
Update contract_file set contact2 = newUser where contflag2 = 'Y'

Thanks

Mike



NOTICE: This message, including any attachment, is intended as a
confidential and privileged communication. If you have received this
message in error, or are not the named recipient(s), please immediately
notify the sender and delete this message.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.


Received: from mail75.messagelabs.com ([216.82.250.3])
by NS1.dekko.com (Lotus Domino Release 8.5.1FP3)
with ESMTP id 2010081814150319-3910 ;
Wed, 18 Aug 2010 14:15:03 -0400
X-VirusChecked: Checked
X-Env-Sender: midrange-l-bounces@xxxxxxxxxxxx
X-Msg-Ref: server-11.tower-75.messagelabs.com!1282155300!50587909!1
X-StarScan-Version: 6.2.4; banners=-,-,-
X-Originating-IP: [69.3.23.26]
X-SpamReason: No, hits=0.0 required=7.0 tests=
Received: (qmail 20171 invoked from network); 18 Aug 2010 18:15:01 -0000
Received: from mailout.midrange.com (HELO mailout.midrange.com) (69.3.23.26)
by server-11.tower-75.messagelabs.com with DHE-RSA-AES256-SHA encrypted SMTP; 18 Aug 2010 18:15:01 -0000
Received: from rivendell.midrange.com (localhost [127.0.0.1])
by mailout.midrange.com (8.14.3/8.14.3) with ESMTP id o7IHxa7e026939;
Wed, 18 Aug 2010 12:59:36 -0500
X-DomainKeys: Sendmail DomainKeys Filter v1.0.0 mailout.midrange.com o7IHxa7e026939
DomainKey-Signature: a=rsa-sha1; s=dk; d=midrange.com; c=simple; q=dns;
b=JDkhpnXO/FHVaGgGeov4uFK5IDrfnsrgG+EyNrqkZNebz6nyVByiQXHh4ZieIywKT
UEVVzhpddzDkzRzT3MuCg==
X-DKIM: Sendmail DKIM Filter v2.8.3 mailout.midrange.com o7IHxa7e026939
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=midrange.com;
s=midrange; t=1282154402;
bh=V9jeQsA7SIt8BxJd8VjjXc+8f9+bDo8WesabMdHvaSQ=;
h=MIME-Version:Subject:Date:Message-ID:In-Reply-To:References:From:
To:Reply-To:List-Id:List-Unsubscribe:List-Archive:List-Post:
List-Help:List-Subscribe:Content-Type:Content-Transfer-Encoding:
Sender;
b=dEuy7X7V0BdLXWmj2Lne2SvWtD9WAyu4f9hRHpXmtGpZTdc1r7NW0Yxj6LOXhJ214
nFEzeOwHvYbmvGIwL62e8MKQZ64JzwSXnnfZTY9sTYt2VdtVSza3nkGstucfDQB/TL
V5Fu+oMo/gA9SUkkPyqXJ1BrBBZyyvJSglbkH0b0=
Received: from TX2EHSOBE003.bigfish.com (tx2ehsobe002.messaging.microsoft.com
[65.55.88.12])
by mailout.midrange.com (8.14.3/8.14.3) with ESMTP id o7IHwwOo026699
for <midrange-l@xxxxxxxxxxxx>; Wed, 18 Aug 2010 12:59:03 -0500
Received: from mail178-tx2-R.bigfish.com (10.9.14.237) by
TX2EHSOBE003.bigfish.com (10.9.40.23) with Microsoft SMTP Server id
8.1.340.0; Wed, 18 Aug 2010 17:58:51 +0000
Received: from mail178-tx2 (localhost.localdomain [127.0.0.1]) by
mail178-tx2-R.bigfish.com (Postfix) with ESMTP id 4E3711208424 for
<midrange-l@xxxxxxxxxxxx>; Wed, 18 Aug 2010 17:58:51 +0000 (UTC)
X-SpamScore: -18
X-BigFish: VPS-18(zz542N62a3L9371Pzz1202hzz8275bhz2fh43h61h)
X-Spam-TCS-SCL: 0:0
Received: from mail178-tx2 (localhost.localdomain [127.0.0.1]) by mail178-tx2
(MessageSwitch) id 1282154330363443_12523;
Wed, 18 Aug 2010 17:58:50 +0000 (UTC)
Received: from TX2EHSMHS049.bigfish.com (unknown [10.9.14.238]) by
mail178-tx2.bigfish.com (Postfix) with ESMTP id 55AFF14D8077 for
<midrange-l@xxxxxxxxxxxx>; Wed, 18 Aug 2010 17:58:50 +0000 (UTC)
Received: from fraexsmtp4.staples.com (12.40.61.103) by
TX2EHSMHS049.bigfish.com (10.9.99.149) with Microsoft SMTP Server id
14.0.482.44; Wed, 18 Aug 2010 17:58:49 +0000
Received: from fraexsmtp2.staplesams.com ([10.3.32.143]) by
fraexsmtp4.staples.com with Microsoft SMTPSVC(6.0.3790.4675);
Wed, 18 Aug 2010 13:58:49 -0400
Received: from nedexmb1.staplesams.com ([10.4.18.109]) by
fraexsmtp2.staplesams.com with Microsoft SMTPSVC(6.0.3790.4675);
Wed, 18 Aug 2010 13:58:49 -0400
X-MimeOLE: Produced By Microsoft Exchange V6.5
MIME-Version: 1.0
Subject: RE: Multiple condition sql
Date: Wed, 18 Aug 2010 13:58:47 -0400
Message-ID: <5AF028844A375D4B98FDCB0627C9AA19064B7BD5@xxxxxxxxxxxxxxxxxxxxxxx>
In-Reply-To: <B369FBDD3799E14CB310EF780B6EBC7B050B5789@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
Thread-Topic: Multiple condition sql
Thread-Index: Acs++/eyqiRyjHsyRW2qpnw3HiqvNAAAevnQ
References: <B369FBDD3799E14CB310EF780B6EBC7B050B5789@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
From: "Morgan, Paul" <Paul.Morgan@xxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
X-OriginalArrivalTime: 18 Aug 2010 17:58:49.0147 (UTC)
FILETIME=[029AC0B0:01CB3EFF]
X-Reverse-DNS: unknown
X-Virus-Scanned: clamav-milter 0.96.1 at rivendell.midrange.com
X-Virus-Status: Clean
X-BeenThere: midrange-l@xxxxxxxxxxxx
X-Mailman-Version: 2.1.9
Precedence: list
Reply-To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
List-Id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
Auto-Submitted: auto-generated
List-Unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>,
<mailto:midrange-l-request@xxxxxxxxxxxx?subject=unsubscribe>
List-Archive: <http://archive.midrange.com/midrange-l>
List-Post: <mailto:midrange-l@xxxxxxxxxxxx>
List-Help: <mailto:midrange-l-request@xxxxxxxxxxxx?subject=help>
List-Subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>,
<mailto:midrange-l-request@xxxxxxxxxxxx?subject=subscribe>
Sender: midrange-l-bounces@xxxxxxxxxxxx
Errors-To: midrange-l-bounces@xxxxxxxxxxxx
X-MIMETrack: Itemize by SMTP Server on INTERNOTES/DEKKO(Release 8.5.1FP3|May 23, 2010) at
08/18/2010 14:15:03,
Serialize by Notes Client on Rob Berendt/DEKKO(Release 8.5.1 FP3|May 24, 2010) at
08/18/2010 02:43:39 PM,
Serialize complete at 08/18/2010 02:43:39 PM
Content-Transfer-Encoding: 7bit
Content-Class: urn:content-classes:message
Content-Type: text/plain; charset="us-ascii"

Something like this will update all three fields on all records. If the flag isn't set that field is updated with the same value:

update contract_file
Set emp = case when empflag = 'Y'
then newUser
else emp
end,
contact1 = case when contflag1 = 'Y'
then newUser
else contact1
end,
contact2 = case when contflag2 = 'Y'
then newUser
else contact2
end

Paul Morgan

Principal Programmer Analyst
IS Supply Chain/Replenishment


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Smith, Mike
Sent: Wednesday, August 18, 2010 1:37 PM
To: Midrange Systems Technical Discussion
Subject: Multiple condition sql

I'm trying to figure out if the following 3 sql statements can be
combined into 1 statement.

I'm trying to update 1 file and set specific field based on flagged
variables from a display file.

Update contract_file set emp = newUser where empflag = 'Y'
Update contract_file set contact1 = newUser where contflag1 = 'Y'
Update contract_file set contact2 = newUser where contflag2 = 'Y'

Thanks

Mike



NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.