Re: SQL Possibily Question

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 03/30/2016 09:31:24
AM:

I have a list of numbers (AP#), Claim#. --> list

In the file F0411 the AP# is stored in the RPRMK field.

I need to update each record in the F0411 where the list.AP# =

F0411.RPRMK

F0411.RPURAT with the list.Claim# field and set
F0411.RPDDJ with 120366, (JDE format of 12/31/2020)

Can this be done in SQL?

Unless I'm sorely mistaken, this should accomplish that.

Update F0411 as a
Set a.RPURAT = (Select LIST.Claim# from LIST
Left Join F0411 as b
On b.RPRMK = LIST.AP#
Where LIST.AP# = a.RPRMK)
, a.RPDDJ = 120366
Where a.RPRMK IN (Select LIST.AP# from LIST
Order By LIST.AP#);


Sincerely,

Dave Clark
int.ext: 91078
direct: (937) 531-6378
home: (937) 751-3300

Winsupply Group Services
3110 Kettering Boulevard
Dayton, Ohio 45439 USA
(937) 294-5331



*********************************************************************************************
This email message and any attachments is for use only by the named
addressee(s) and may contain confidential, privileged and/or proprietary
information. If you have received this message in error, please
immediately notify the sender and delete and destroy the message and all
copies. All unauthorized direct or indirect use or disclosure of this
message is strictly prohibited. No right to confidentiality or privilege
is waived or lost by any error in transmission.
*********************************************************************************************