Advertisement
r0b0_sk

Untitled

Feb 27th, 2020
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  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. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement