Re: Combining SQL Updates

[Alan Campin <alan0307d@xxxxxxxxx>]

Case statement?


On Mon, Jan 29, 2018 at 2:31 PM, <dlclark@xxxxxxxxxxxxxxxx> wrote:

>         I have a curiosity question that hopefully might also teach me
> more about SQL set-based processing.  We added a foreign key to an
> existing table.  To initialize the new column, we ran the following two
> updated statements.  My question is whether there is a way to do this as a
> single update set -- rather than processing the table twice?
>
>
> Update SOOSH01T
>    Set SOWFSTSTID  = (Select SOWFSTSTID from SOWFSTST
>                        Where WRKFLWCDE = 'DELIVERED')
>  Where SOOSH01TID in (Select SOOSH01TID from SOOSH00V03
>                        Where SHPSTSCDE = 'Closed');
>
> Update SOOSH01T
>    Set SOWFSTSTID  = (Select SOWFSTSTID from SOWFSTST
>                        Where WRKFLWCDE = 'WAREHOUSEREADY')
>  Where SOOSH01TID in (Select SOOSH01TID from SOOSH00V03
>                        Where SHPSTSCDE <> 'Closed');
>
>
> 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.
> ************************************************************
> *********************************
> --
> 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: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD