SHARE
TWEET

Untitled

r0b0_sk Feb 27th, 2020 71 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2. UPDATE AcmVoucher
  3.    SET erp_target_1 = 2 /* DO_NOT_TRANSFER */
  4.  WHERE id IN (
  5.  SELECT v.id
  6.   FROM AcmVoucher v
  7.   JOIN AcmVoucherType vt
  8.     ON v.voucher_type_id = vt.id
  9.  WHERE v.erp_target_1 = 0
  10.    AND v.voucher_state_id=1000
  11.    AND BITAND(vt.flags, 2) = 0
  12.  )
  13.  
  14. UPDATE AcmEntry
  15.    SET erp_target_1 = 2 /* DO_NOT_TRANSFER */
  16.  WHERE voucher_id IN (
  17.  SELECT v.id
  18.   FROM AcmVoucher v
  19.   JOIN AcmVoucherType vt
  20.     ON v.voucher_type_id = vt.id
  21.  WHERE v.erp_target_1 = 0
  22.    AND v.voucher_state_id=1000
  23.    AND BITAND(vt.flags, 2) = 0
  24.  )
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top