Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE AcmVoucher
- SET erp_target_1 = 2 /* DO_NOT_TRANSFER */
- WHERE id IN (
- SELECT v.id
- FROM AcmVoucher v
- JOIN AcmVoucherType vt
- ON v.voucher_type_id = vt.id
- WHERE v.erp_target_1 = 0
- AND v.voucher_state_id=1000
- AND BITAND(vt.flags, 2) = 0
- )
- UPDATE AcmEntry
- SET erp_target_1 = 2 /* DO_NOT_TRANSFER */
- WHERE voucher_id IN (
- SELECT v.id
- FROM AcmVoucher v
- JOIN AcmVoucherType vt
- ON v.voucher_type_id = vt.id
- WHERE v.erp_target_1 = 0
- AND v.voucher_state_id=1000
- AND BITAND(vt.flags, 2) = 0
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement