• Replies 1 reply
  • Subscribers 337 subscribers
  • Views 51 views
  • Users 0 members are here
Related

Changing MOD in bulk

Jen Skelly
$organization

Hi All, 

I am having a moment here. 

I am trying to update the MOD on some orders. 

SUPER simple parameters here...basically if is it Mail and after June 1st, change to PAH. 

I simply can't make it happen. 

Thoughts? 

I know it's going to be a small syntax thing I am not thinking of, but can you lend a desperate girl a hand. 

Jen 

Grinning

Parents
  • $organization

    See...all I had to go and do was type this....figured it out right away. 

    Thanks all 

    (for those interested...it was a typo in my greater than or less than. I had it less than 0.00. OOPS 

    update T_order
    set delivery = 4
    from T_order
    where delivery = 2

    and order_dt > '06-01-2021' and tot_paid_amt > 0.00 and customer_no = 32677

Reply
  • $organization

    See...all I had to go and do was type this....figured it out right away. 

    Thanks all 

    (for those interested...it was a typo in my greater than or less than. I had it less than 0.00. OOPS 

    update T_order
    set delivery = 4
    from T_order
    where delivery = 2

    and order_dt > '06-01-2021' and tot_paid_amt > 0.00 and customer_no = 32677

Children
No Data