SELECT F_OrderNo,* FROM VRYF_t_Cust_Entry100021
WHERE fid=100011
--WHERE F_OrderNo LIKE '%ȋ%'


--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