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.
midrange.com
