USE T24S001
UPDATE BILL_ITEM_DETAIL SET PurSrNo = ''
UPDATE BILL_ITEM_DETAIL SET PurSrNo = T1.F1 FROM (SELECT SrNo AS F1, ItemBillNo AS F2 FROM FINISHED_PURCHASE_ITEM_DETAIL) AS T1 WHERE BillNo COLLATE DATABASE_DEFAULT = T1.F2