15 lines
561 B
MySQL
15 lines
561 B
MySQL
|
SELECT F_OrderNo,* FROM VRYF_t_Cust_Entry100021
|
|||
|
|
WHERE fid=100011
|
|||
|
|
--WHERE F_OrderNo LIKE '%<25><>%'
|
|||
|
|
|
|||
|
|
|
|||
|
|
--SELECT * FROM VRYF_t_Cust100013
|
|||
|
|
|
|||
|
|
--SELECT * INTO T_SAL_ORDER_back202504231951 FROM T_SAL_ORDER
|
|||
|
|
BEGIN TRAN
|
|||
|
|
UPDATE T_SAL_ORDER SET F_Amount=bb.F_Amount
|
|||
|
|
FROM (
|
|||
|
|
SELECT a.fid,a.F_Amount AS dddd,b.F_Amount FROM dbo.T_SAL_ORDER a
|
|||
|
|
INNER JOIN VRYF_t_Cust_Entry100021 b ON a.F_contractnumber=b.F_ORDERNO
|
|||
|
|
WHERE a.F_SALEORGID=100302 AND ISNULL(a.F_Amount,0)=0 AND b.fid=100011 AND b.F_Amount<>0) bb
|
|||
|
|
WHERE T_SAL_ORDER.F_SALEORGID=100302 AND ISNULL(T_SAL_ORDER.F_Amount,0)=0
|