use e25t001



UPDATE OUTWARD_CHALLAN_DETAIL SET InwSrNo = '' WHERE LEN(InwSrNo)=5
UPDATE OUTWARD_CHALLAN_DETAIL SET InwSrNo = T1.F1 FROM (SELECT SrNo AS F1, ChallanNo AS F2, WeaverCode AS F3, Voucher AS F4, InwLotNo AS F5 FROM OPENING_INWARD) AS T1, (SELECT PartyCode AS K1, SrNo AS K2 FROM OUTWARD_CHALLAN) AS T2 WHERE T1.F2 COLLATE DATABASE_DEFAULT = InwChNo AND T1.F3 = T2.K1 AND SrNo = T2.K2 AND T1.F5 COLLATE DATABASE_DEFAULT= InwLotNo