Initialize the outgoing task

-- initialize the summary of the exit order, remove the task list and clear the wave number.

Update out_sale_billing_m set sf_ycw_sl=' No 'where DJBH =' XHBB00000414140'

BEGIN

FOR C IN (SELECT * FROM OUT_SALE_BILLING_M WHERE DJBH = 'XHBB00000414140') LOOP

UPDATE out_sale_billing_m T

SET zyzt = '0century dint T.SFhammer YCWP SL =' No', t.sfrankgqcards'No'- -, SF_YBDD=' No'

WHERE djbh = c.djbh

AND yzid = c.yzid

UPDATE out_sale_billing_D T SET zyzt = '0perfect WHERE djbh T.SLZ LHWCL = T.SLR Magazine ZJWCL = 0, T.SL_KCBZ = 0recedent t.sfrankgqcards' No', T.SF_YCW_SL ='No 'WHERE djbh = c.djbh AND yzid = c.yzid; DELETE FROM OUT_SALE_TASK_D WHERE DJBH= C.DJBH AND YZID = C.YZIDentDelete FROM OUT_SALE_TASK_M WHERE DJBH= C.DJBH AND YZID = C.YZID

END LOOP

END

UPDATE out_sale_billing_m set BCH='' WHERE DJBH = 'XHBB00000414140'