Change Customer Priority GP

select CUSTPRIORITY,* from rm00101 where CUSTPRIORITY = '0'

begin tran

update RM00101 
set CUSTPRIORITY = '1'
where CUSTPRIORITY = '0' and CUSTNMBR = 'MIROIN9993'
commit tran

Leave a Reply