BEGIN TRAN
UPDATE VENDTABLE
SET CURRENCY = L.ACCOUNTINGCURRENCY
--SELECT VT.ACCOUNTNUM,VT.CURRENCY,VT.DATAAREAID,L.NAME,L.ACCOUNTINGCURRENCY
FROM VENDTABLE AS VT
INNER JOIN LEDGER AS L
ON L.NAME = VT.DATAAREAID
WHERE VT.CURRENCY = ''
ORDER BY VT.DATAAREAID,VT.ACCOUNTNUM,VT.CURRENCY
--COMMIT
No comments:
Post a Comment