Jul 3, 2017

Vendor의 통화가 빈값인 데이터 Ledger기준으로 업데이트 하기

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