USE T20A001

UPDATE OPENING_GREY_AT_SHOP SET TransLRNo=RIGHT(TransLRNo+ '*',15) WHERE TransLRNo<>''




UPDATE BILL_ITEM_DETAIL SET PurSrNo = T1.F1 FROM (SELECT OPENING_GREY_AT_SHOP.SrNo AS F1, BILL_ITEM_DETAIL.PurSrNo AS F2, BILL_DETAIL.BillNo AS F3 FROM BILL_DETAIL INNER JOIN BILL_ITEM_DETAIL ON BILL_DETAIL.BillNo = BILL_ITEM_DETAIL.BillNo INNER JOIN OPENING_GREY_AT_SHOP ON BILL_DETAIL.TransLRNo = OPENING_GREY_AT_SHOP.TransLRNo) AS T1 WHERE T1.F3 = BillNo